If a cell is blank(not zero) return 0 if it is a number or 0 return 10?

**jaganath** · 03-12-2010, 03:36 PM

If A1 is blank I would like B1 to be blank also, If (A1 is 0 / date / or has anything in it) I would like B1 to be 10. How would I do that? Thanks.

**JBeaucaire** · 03-12-2010, 03:39 PM

You can't insert "Blank" status into a cell with a formula, but you can insert a nullstring. Put this in B1:

=IF(ISBLANK(A1),"",10)

**rmc5446** · 03-12-2010, 03:45 PM

you can use:

=if(a1="","",10)

**jaganath** · 03-12-2010, 04:11 PM

if a post is solved how would I indicate that??

**esupply** · 03-12-2010, 04:36 PM

Go to advanced reply and look next to the title, you can change it there

**JBeaucaire** · 03-12-2010, 07:33 PM

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

Re: If a cell is blank(not zero) return 0 if it is a number or 0 return 10?