Ask Your Question

Fixing formula seeing blank spreadsheet cell same as cell with 0 in it

asked 2018-08-20 17:42:28 +0200

Barrowman gravatar image

I have this formula IF(D25=0,"No Report","") in cell I25 but if I delete the 0 it still says "No Report" If I now put a space character in the cell D25 or a different number I25 clears.

Can someone suggest a formula which shows "No Report" only if 0 in D25 please?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-08-20 18:15:00 +0200

erAck gravatar image
=IF(AND(NOT(ISBLANK(D25)),D25=0),"No Report","")
edit flag offensive delete link more


Excellent thanks. I don't think I would have thought about trying that syntax.

Barrowman gravatar imageBarrowman ( 2018-08-20 18:30:26 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-20 17:42:28 +0200

Seen: 39 times

Last updated: Aug 20 '18