M/S Excel, cover up errors

[tomh]

The message #div/o! is coming up on my spreadsheet as to be expected as i am dividing by 0 this is because enitially there is no data in the sheet however is there a way to cover it up or stop it from happening
cheers

 

[dsi]

You can use an IF statement for your expression:

=IF(B1<>0,A1/B1,&quot;&quot;)

 

[Dreamboat]

=if(isblank(a1),"",a1/b1)

techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[bkpchs237]

Either of these formulas should mask the error message when you have a blank or a zero in the cell:

=IF(OR(ISBLANK(b1),b1=0),"",a1/b1)

=IF(OR(b1=0,b1="&quot,"",a1/b1)