I'm trying to get an IF function to give me the choice of 3 different
percentage options from one cell. This is what I put in as my function in
cell BG37:
=IF(AA11<=30,S11*0.18,IF(AA11=31<90,S11*0.22,IF(AA 1190,S11*0.26)))

Where I want cell BG37 to multiply cell AA11 by 18% if cell S11 is < or = to
30
or
Cell BG37 to multiply cell AA11 by 22% if cell S11 is = to 31 but <90
lastly
Cell BG37 to multip;y cell AA11 by 26% if cell S11 or = to 90

The way I have it, the 1st and 3rd function work but the second one shows
FALSE if cell S11 is between 31 and 89.

--
Loren