need formula help

[tom]

I'm trying to have a formula do 3 scenerios in one cell and have a partial
formula working: IF(AND(G39>30, G39<=7),3000) which equates to if cell G39 is
greater than 0 and less than or equal to 7 use 3000. I would like to
continue the formula that if G39 is greater than 7 and less than 14 use 5000
and if G39 is greater than 14 use 7500. How can I do this?

 

[Eduardo]

Hi,

=IF(AND(G39>0, G39<=7),3000,IF(AND(G39>7, G39<=14),5000,if(G39>14,7500)))

 

[Dan]

=IF(AND(G39>30,G39<=7),3000,IF(AND(G39>7,G39<14),5000,IF(G39>14,7500,0)

care to what is more important to you.. 1st items will cancel later items,
even if they are also true. you can change the order in which they occur.

 

[tom]

thank you!

Hi,

=IF(AND(G39>0, G39<=7),3000,IF(AND(G39>7, G39<=14),5000,if(G39>14,7500)))

 

[Dan]

correction on formula, needs 2 more parenthesis
=IF(AND(G39>30,G39<=7),3000,IF(AND(G39>7,G39<14),5000,IF(G39>14,7500,0)))

 

[Mike H]

Maybe a bit shorter

=LOOKUP(G39,{0,8,15},{3000,5000,7500})
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[מיכ×ל (מיקי) ×בידן]

Does this segment make sense: AND(G39>30,G39<=7),... ?
Micky