need formula help
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.
"tom" wrote:
I'm trying to have a formula do 3 scenerios in one cell and have a partial
formula working: IF(AND(G3930, 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?
|