IF OR Statement

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

 

[Frank Kabel]

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

 

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

 

[Frank Kabel]

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