Negative currency in E5, how to get "loss" text in A5?

Giganews Newsgroups
Subject: Negative currency in E5, how to get "loss" text in A5?
Posted by:  StargateFan (IDon'tAcceptSp…@NoJunkMail.com)
Date: Thu, 20 Jan 2011

If =E4-E2 formula in E5 shows a negative number meaning income loss,
how can we have text in A5 say "Income Loss".  And it would label cell
as "Income Gain" if the number in E5 is positive?  Thx.  :oD

Replies