Multiple IF functions, differant range requires differant calculation

[Spoontang]

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))))))))))))))

 

[jtakw]

Hi,

Your formula modified:

Book1
	C	F
1	3150
13		10
Sheet8

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

 

[Spoontang]

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]

You're welcome, welcome to the forum.

Cheers, Happy Australia Day.