please help again

G

Guest

Michael helped me with part of this earlier today. I'm
stuck again.
The below formula works well; however, I want to
add "(35200)" and "(35300)" to the formula in additon to
the "(00140)" and cannot get it to work.
Can you help?

=IF(AND(I7="(00140)",K21>J21),75%*(K21-J21),0)
 
B

Bob Phillips

Do you want

=IF(AND(OR(I7="(00140)",I7="(35200)",I7="(35300)"),K21>J21),75%*(K21-J21),0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

Guest

Thank you so much Bob, that is exactly what I wanted and
could not get. You too are a keeper :)
 
Top