software

I want to put a formula in a cell subtracting two dates and if the days or
greater than 11 I want it to say quot;problemquot; instead of true or false. Is
this possible


=if(date1-date2lt;0,quot;word1quot;,quot;word2quot;)--
robert111
------------------------------------------------------------------------
robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
View this thread: www.excelforum.com/showthread...hreadid=522631One way:

=IF(B1-A1gt;11,quot;problemquot;, quot;no problemquot;)

In article gt;,
GG gt; wrote:

gt; I want to put a formula in a cell subtracting two dates and if the days or
gt; greater than 11 I want it to say quot;problemquot; instead of true or false. Is
gt; this possible

=if(abs(b1-a1)gt;11,quot;Problemquot;,b1-a1)

or

=if(abs(b1-a1)gt;11,quot;Problemquot;,quot;OKquot;)

--
Regards,
Tom Ogilvyquot;GGquot; wrote:

gt; I want to put a formula in a cell subtracting two dates and if the days or
gt; greater than 11 I want it to say quot;problemquot; instead of true or false. Is
gt; this possible