please help again

  • Thread starter Thread starter Guest
  • Start date Start date
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)
 
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)
 
Thank you so much Bob, that is exactly what I wanted and
could not get. You too are a keeper :)
 
Back
Top