View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Tom Ogilvy
 
Posts: n/a
Default 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