Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank cell
Hello,
I have a spread sheet which tracks whether an item has been paid or not. It also looks at the amount claimed and compares this to the amount paid and returns either "PAID", "UNDERPAID" or "OVERPAID". The problem is, if the amount paid cell is blank the status defaults to "PAID". Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If cell blank return a blank | Excel Worksheet Functions | |||
add blank space in cell if first name is not blank | Excel Worksheet Functions | |||
how to get excel to display blank if reference cell blank | Excel Worksheet Functions | |||
How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) |