Or you could simplify =IF(J3="E",NA(),IF(E25-F19-E22<=0,0,E25-F19-E22)) to
=IF(J3="E",NA(),MAX(E25-F19-E22,0))
--
David Biddulph

"David Biddulph" wrote in message
...
=IF(J3="E",NA(),IF(E25-F19-E22<=0,0,E25-F19-E22))
or replace NA() by "N/A" if you actually want the text string N/A rather
than the error value #N/A

"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.