IF Functions
=IF(AA11<=30,S11*0.18,IF(AA11<=90,S11*0.22,S11*0.2 6)))
not checked
------------------------
means:
=IF(AA11<=30,S11*0.18,
else IF(AA11<=90,S11*0.22,
else S11*0.26)))
"DirtTrux" wrote in message
...
I'm trying to set up a cell with IF functions such as:
I want cell BG37 to multiply cell S11 by 18% if cell AA11 is <=30 or
multiply cell S11 by 22% if cell AA11 is 30 but <91 or multiply cell S11
by
26% if cell AA11 91.
Here is the formula I entered in cell BG37:
=IF(AA11<=30,S11*0.18,IF(AA11=31<90,S11*0.22,IF(AA 1190,S11*0.26)))
The 1st function works and the last function works but the 2nd function
says
FALSE if the value in AA11 is between 31 to 90.
|