INSTEAD OF FORMULA SAYING TRUE OR FALSE I WANT IT TO SAY something
 

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 "problem" instead of true or false. Is
this possible

INSTEAD OF FORMULA SAYING TRUE OR FALSE I WANT IT TO SAY something
 

=if(date1-date2<0,"word1","word2")


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=522631

INSTEAD OF FORMULA SAYING TRUE OR FALSE I WANT IT TO SAY something
 

One way:

=IF(B1-A111,"problem", "no problem")

In article ,
GG wrote:

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 "problem" instead of true or false. Is
this possible

INSTEAD OF FORMULA SAYING TRUE OR FALSE I WANT IT TO SAY something
 

=if(abs(b1-a1)11,"Problem",b1-a1)

or

=if(abs(b1-a1)11,"Problem","OK")

--
Regards,
Tom Ogilvy


"GG" wrote:

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 "problem" instead of true or false. Is
this possible