IF Statement

[Moxioron]

Hello all.

Here is what I am trying to do:

IF F6 < 25, $1,200
IF F6 > 72 AND < 80, $2,400
IF F6 >= 80, $3,600

I am certain there is a simple formula, but I just can't seem to think today!

Thank you.

 

[MrKowz]

What do you want if F6 is between 25 and 72?

 

[Moxioron]

Nothing... it's a job grade thing ... 14 - 25 72 - 80 and then > 80

Thank you.

 

[MrKowz]

Gotcha, try:

=LOOKUP(F6,{0,14,25,73,80},{"",1200,"",2400,3600})

This will return:

• 0-13 = Blank
• 14-24 = 1200
• 25-72 = Blank
• 73-79 = 2400
• 80+ = 3600

 

[Trouttrap2]

The lookup function works great for this. If you are interested in seeing the "if"and "then" here is another way.
=IF(AND(F6>72,F6<80),2400,IF(F6<25,1200,IF(F6>=80,3600,"")))

 

[Moxioron]

Worked like a charm. Thank you for taking time to assist me.