Home |
Search |
Today's Posts |
#1
|
|||
|
|||
if blank formula
is there a formula that will do this?
formating conditioning / formula is =ifblank(c60),omitpayment:") that is what I have but it is not working. what am I doing wrong? @@ I want, if the cell is blank to show Payment Omitted @@ |
#2
|
|||
|
|||
I'm not completely clear on your question, but I think this is what you're
looking for. =IF(ISBLANK(C60),"Payment Omitted","") that formula will test to see if c60 is blank, and if it is, will put "payment omitted." if it is not blank it will return nothing. "Colin2u" wrote: is there a formula that will do this? formating conditioning / formula is =ifblank(c60),omitpayment:") that is what I have but it is not working. what am I doing wrong? @@ I want, if the cell is blank to show Payment Omitted @@ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
blank data field shows quote in formula, how to delete it? | Excel Discussion (Misc queries) | |||
Blank a cell using a formula | Excel Discussion (Misc queries) |