SPREADSHEET

flkulchar · Sep 24, 2004

Re: Posting above..

the same is true if I divide 0 by 0.

My cell displays "VALUE"!!

I wish it to appear blank.

pls advise.

Patti · Sep 24, 2004

Try

=IF(ISERROR(A1/B1),"",(A1/B1))

Changing A1 and B1 for your cells.