Re: Help With Time Sheet Formula

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

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" <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
    ... 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: Refresh of data
    ... Or, if there is some event going on that triggers your calculation, in ... Roger Govier ... When I modify my UDF in VBA and compile it, ...
    (microsoft.public.excel.programming)
  • Re: I have a problem with "LEFT" formula
    ... "Roger Govier" wrote: ... Excel will follow the setting of the first file opened. ... then you may want to turn calculation to manual. ...
    (microsoft.public.excel.misc)
  • Re: Strange calculation in PivotTable
    ... "Roger Govier" wrote: ... that the Calculated field is doing its calculation ... I assume firm order is the same as Quantity in the equation ... a calculated formula for order quantity which should ...
    (microsoft.public.excel.worksheet.functions)