need formula help

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?
 
D

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.
 
D

David Biddulph

IF(G39<=0, "", IF(G39<=7,3000, IF(G39<14,5000, IF(G39>14,7500,"G39 is equal
to 14"))))
 
D

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)))
 
M

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
 
D

David Biddulph

The 30 is a typo. If you look at the OP you'll see that it refers to zero.
 

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

Top