View Single Post
  #2   Report Post  
Eddie O
 
Posts: n/a
Default

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 @@