IF OR Statement

M

Michelle

I am trying to figure out a formula that states, IF a
certain row equals June, July or August, then mutiply by
a certain row.

I started a test formula and I am getting #Value errors:
The test formula is =IF(J7="JUNE",OR("JULY",OR
("AUGUST"),K22*L22))

Thanks for your help.

Tavia.
 
G

Guest

Thank you. But I left out one part.

I wanted to say if AF7=2 and J7 = June, July or August,
then k22*l22.

Thanks again.
 
F

Frank Kabel

Hi
try
=IF(AND(AF7=2,OR(J7="JUNE",J7="JULY",J7="AUGUST")),K22*L22,"not
defined")
 
Top