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

[GG]

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

[robert111]

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

[JE McGimpsey]

One way:

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

In article <3C364D83-E71C-45EA-BBF8-A1B4CBC84F18@microsoft.com>,
GG <GG@discussions.microsoft.com> 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

[Tom Ogilvy]

=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