need formula help

  • Thread starter Thread starter tom
  • Start date Start date
T

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?
 
=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.
 
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)))
 
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
 
Back
Top