if blank formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 @@
 
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.
 
Back
Top