Change Text in Cell depending on another cell value (1 Viewer)

[Poppa Smurf]

I am new to Excel 2007 and need some help please.

Suppose I want the text in cell A10 to change depending on the value in B10.

As an example if B10 is less than zero, the text in A10 is show Loss. If B10 is 0 or above then the text in A10 is to show Profit.

 

[Brianwarnock]

=IF(B10<0,"loss","Profit")

entered in A10 solves the example given

Brian

 

[Poppa Smurf]

Brian

Thank you, it works.

My problem was that I was trying to use a rule in conditional formatting.