IF OR AND Statement

M

Michelle

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.


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

--
Regards
Frank Kabel
Frankfurt, Germany


Michelle wrote:
Click to expand...
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.
 
J

JE McGimpsey

See the reply to your initial thread.

Please don't start a new thread for a continued topic - it just
fragments your answers, and potentially wastes the time of those
replying to an answered question.
 
R

RagDyer

Try this:

=IF(AND(AF7=2,OR(J7={"June","July","August"})),K22*L22,"")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

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.


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

--
Regards
Frank Kabel
Frankfurt, Germany


Michelle wrote:
Click to expand...
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.
 
Top