logical test

L

LisaD

Stumped on this one... is it possible to have more than one logical test
using the "IF" function? My example:

C9 is a drop down that includes months (i.e. Jul, Mid-Jul, End-Jul). I need
to calculate all the July's, not just "Jul".

This is what I need, but I don't know how to setup it up.
IF C9 = "Jul" or "Mid-Jul" or "End-Jul", 40*E9, 0

Many thanks!!
 
E

Elkar

You can use the AND and OR functions. Try this:

=IF(OR(C9={"jul","mid-jul","end-jul"}),40*E9,0)

HTH,
Elkar
 
B

bclancy12

You can also use =IF(C9=mid-jul, 40*E9,0)+IF(C9=End-Jul, 40*E9,0)+IF(etc. etc.

this will basically take the 3 IF statements, complete the math, and add
together the results.
 
L

LisaD

Thank you for your quick reply... most helpful!!

Elkar said:
You can use the AND and OR functions. Try this:

=IF(OR(C9={"jul","mid-jul","end-jul"}),40*E9,0)

HTH,
Elkar
Click to expand...
 
Top