IF Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(AA11>90,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(AA11<=30,S11*0.18,IF(AA11<=90,S11*0.22,S11*0.26)))

not checked
------------------------
means:
=IF(AA11<=30,S11*0.18,

else IF(AA11<=90,S11*0.22,

else S11*0.26)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF function won't do want I want 6
Evaluating more than 30 conditions using a formula 1
Function doesn't pick up certain cell reference 8
Conditional Formatting Formula propogating incorrectly 2
Here's one for you...(thanks for the help in advance) 2
Problem with SUMIF 3
Average IF? 1
If and Countif 2

Back
Top