Help With Time Sheet Formula
 

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

Help With Time Sheet Formula
 

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.

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.

Help With Time Sheet Formula
 

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.