"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=IF(AND(E19<0,G19=0,F190),C19*E19,0)
as the OP asked for 0, rather than 1, for the exception case.

Thanks for correction, David.
It should be as you mentioned above.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---