Thread: Changing text in other cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Changing text in other cells
Of course the 1 should be a zero

=if(A1<0,"A1 is negative","Non Negative Text")

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
=if(A1<1,"A1 is negative","Non Negative Text")

--
Regards,
Tom Ogilvy


"Excel ProgrammingMe" <Excel
wrote
in message ...
I'd like the text in one cell to change if the value
of another cell becomes negative. How can I get that to
happen?




Reply With QuoteReply With Quote