# Multiple IF functions, differant range requires differant calculation

#### Spoontang

##### New Member
Hi Guys, I'm new here and new to anything but the basics of excel. Trying to make a cell for fuel tank capacity based on the height (dip) of the fuel. Tank is uneven. The individual formulas work in a sheet where you have to put the figure in the corresponding cell, e.g between 43 to 63, however I can't make all of it work as a one cell calculation. The first and last do work, the others return FALSE. Your help would be appreciated, I've tried adding AND, also "" and writing it different ways from what I've seen on the forum without success.

=IF(IF(F13>127,F13*110+4020,
(IF(F13>110<=127,F13*128+1830,
(IF(F13>62<=110,F13*131+1500,
(IF(F13>42<=62,F13*127+1710,
(IF(F13>30<=42,F13*123+1855,
(IF(F13>15<=30,F13*120+1935,
(IF(F13<=15,F13*117+1980))))))))))))))

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Hi,

#### Spoontang

##### New Member
Thank you jtakw, I see I had a few errors in how I did this. Your time and knowledge in replying to this is much appreciated. I got to the very frustrated stage....
I can now leave this and go enjoy the rest of Australia day with a cold beer or two.
Cheers,

#### jtakw

##### Well-known Member
You're welcome, welcome to the forum.

Cheers, Happy Australia Day.