Help With Time Sheet Formula
=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
--
David Biddulph
"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.
|