On Jan 14, 2:50*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Change
=IF(AND(E3="ZEMO",M3="ZM"),U3,0) to
=IF(AND(E3="ZEMO",M3<"ZM"),U3,0)
--
David Biddulph

"enquirer2" wrote in message

...

Hi Pete
Thanks for your reply. *I've tried this but can't get it to work.
I've also seen my mistake, which is I actually require U3 if E3=ZEMO
is true, but only if M3=ZM is false.
so if E3=ZEMO and M3 is a blank cell, U3 is Displayed. *If not, 0.
On Jan 14, 11:58 am, Pete_UK wrote:
*Try this:

=IF(AND(E3="ZEMO",M3="ZM"),U3,0)

...

Thanks ever so much for all your help chaps. All works fine now.
Simon =IF(AND(E3="ZEMO",M3<"ZM"),U3,0)