Formula Help (Continued)

  • Thread starter Thread starter Jay Gustafson
  • Start date Start date
J

Jay Gustafson

Hello,

I had posted my origional question yesterday, which I did receive an answer for. But I just need one modification added to the formula.

=IF(OR(A1="Saved",A1="lost")," -- ",NOW()-B1)

If cell B1 does NOT have a date, then I don't want there to be an error value (#########).

Thank you,
Jay
 
Hi

Try this:
=IF(OR(A1="Saved",A1="lost")," -- ",IF(B1<>0,NOW()-B1,""))

--
Andy.


Hello,

I had posted my origional question yesterday, which I did receive an answer for. But I just need one modification added to the formula.

=IF(OR(A1="Saved",A1="lost")," -- ",NOW()-B1)

If cell B1 does NOT have a date, then I don't want there to be an error value (#########).

Thank you,
Jay
 
This was perfect. Thank you Andy!
<Andy B> wrote in message Hi

Try this:
=IF(OR(A1="Saved",A1="lost")," -- ",IF(B1<>0,NOW()-B1,""))

--
Andy.


Hello,

I had posted my origional question yesterday, which I did receive an answer for. But I just need one modification added to the formula.

=IF(OR(A1="Saved",A1="lost")," -- ",NOW()-B1)

If cell B1 does NOT have a date, then I don't want there to be an error value (#########).

Thank you,
Jay
 
Back
Top