software

Hello All,

I'm using this formula, =DATEDIF(E8,NOW(), quot;yquot; ). This returns a 1. I have a
spread sheet that determines if an instrument needs to be calibrated after
it's year calibration is up. I would like to use a nested IF statement so
that when the one year calibration is up it will return a text string quot;NEEDS
CALIBRATIONquot; instead of a 1.

Thanks,

=if(DATEDIF(E8,NOW(),quot;yquot;)gt;=1,quot;Needs Calibrationquot;,quot;Not Yetquot;)

Excel User001 wrote:
gt;
gt; Hello All,
gt;
gt; I'm using this formula, =DATEDIF(E8,NOW(), quot;yquot; ). This returns a 1. I have a
gt; spread sheet that determines if an instrument needs to be calibrated after
gt; it's year calibration is up. I would like to use a nested IF statement so
gt; that when the one year calibration is up it will return a text string quot;NEEDS
gt; CALIBRATIONquot; instead of a 1.
gt;
gt; Thanks,

--

Dave Peterson

Works great!!! Thank you very much for all your help!

quot;Excel User001quot; wrote:

gt; Hello All,
gt;
gt; I'm using this formula, =DATEDIF(E8,NOW(), quot;yquot; ). This returns a 1. I have a
gt; spread sheet that determines if an instrument needs to be calibrated after
gt; it's year calibration is up. I would like to use a nested IF statement so
gt; that when the one year calibration is up it will return a text string quot;NEEDS
gt; CALIBRATIONquot; instead of a 1.
gt;
gt; Thanks,