Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Statement | Excel Worksheet Functions | |||
Conditional If Statement | Excel Discussion (Misc queries) | |||
Conditional If statement | Excel Worksheet Functions | |||
conditional statement | New Users to Excel | |||
Conditional IF statement | Excel Programming |