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

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

One way:

=IF(B1-A1>11,"problem", "no problem")

In article <[email protected]>,
GG <[email protected]> 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

=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