Re: Help With Time Sheet Formula

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

=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" <BECKYB913@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EF928C5A-2E46-404D-BDD9-5DEAAB8CBBC7@xxxxxxxxxxxxxxxx

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.


.

Relevant Pages

  • Re: Help With Time Sheet Formula
    ... David Biddulph ... I'm using the following formula and it works, however I need to modify it ... instead of performing the above calculation I need "N/A" inserted. ...
    (microsoft.public.excel.misc)
  • Re: Help With Time Sheet Formula
    ... Roger Govier ... I'm using the following formula and it works, however I need to modify ... instead of performing the above calculation I need "N/A" inserted. ...
    (microsoft.public.excel.misc)
  • Re: Excel 2007 calculate time between 2 date/time columns
    ... I have decided on using the following but the calculation ... trying to calculate the time difference, assuming that working hours = 14 ... "Fred Smith" wrote: ... >>> David Biddulph ...
    (microsoft.public.excel.misc)
  • Re: Formula Question
    ... How would I modify so it does the calculation only ... original thread. ... First, for XL2007 and later, the original formula could simplified as ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Calculating someones age at a given date
    ... that will tell me WHEN a child reaches the age of 5. ... "David Biddulph" wrote: ...
    (microsoft.public.excel.worksheet.functions)