conditional written statement

  • Thread starter Thread starter frankg
  • Start date Start date
F

frankg

I have a spreadsheet which computes the remaining funds in an escrow
account in dollars. When the escrow amount is short, the spreadsheet
puts the amount in parenthesis. Let's say for this example it reads
that the escrow is short $50.00. Now in this condition I want another
cell to read " the escrow is short" in this condition only (that being
the escrow is showing a shortage). If there is no shortage or if it
reads zero dollars I don't want any statement to be written
(inotherwords ignore the amount and write no statement).

Is there a simple way to perform this condition using perhaps an
" IF " statement ? Please keep it simple as I consider myself a
beginner in this stuff.
 
frankg said:
I have a spreadsheet which computes the remaining funds in an escrow
account in dollars. When the escrow amount is short, the spreadsheet
puts the amount in parenthesis. Let's say for this example it reads
that the escrow is short $50.00. Now in this condition I want another
cell to read " the escrow is short" in this condition only (that being
the escrow is showing a shortage). If there is no shortage or if it
reads zero dollars I don't want any statement to be written
(inotherwords ignore the amount and write no statement).

Is there a simple way to perform this condition using perhaps an
" IF " statement ? Please keep it simple as I consider myself a
beginner in this stuff.

Let's say the cell with the $ figure in it was A1. Then try this formula in
another cell:
=IF(A1<0,"the escrow is short","")
 
Let's say the cell with the $ figure in it was A1. Then try this formula in
another cell:
=IF(A1<0,"the escrow is short","")

That works perfect.
Thanks a lot.

ps-- I really enjoy this newsgroup. One of the few I frequent that
seems to lack the flames in quantity like some of the others. Seems
like people here really enjoy and help people. Great !!
 
Back
Top