Hi Becky

=IF(J3="E",NA(),IF(E25-F19-E22<=0,0,E25-F19-E22))

or simplified to
=IF(J3="E",NA(),MAX(0,E25-F19-E22))


--
Regards

Roger Govier


"BECKYB913" wrote in message
...

I'm using the following formula and it works, however I need to modify
it to
cover an additional condition. My formula is:

IF(E25-F19-E22<=0,0,E25-F19-E22)


I want the above to occur unless cell J3 is equal to "E". If cell J3
= "E",
instead of performing the above calculation I need "N/A" inserted.



Thanks.