IF Functions
 

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.

IF Functions
 

something like
=if(aa1191,.26,if(aa1130,.22,.18))*s11

--
Don Guillett
SalesAid Software

"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.

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.