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

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

HTH,
Elkar


"LisaD" wrote:

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!!