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.

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