Like to format cells

[NYBoy]

I like to format the cell so that #DIV/0 wouldn't apper in the cell i
parent data is not available yet.

e.g.

A1 = A2/A3
BI = B2/B3
C2 = C2/C3
and so on.......

data for A2,A3,B2,B3 are available but
data for C2,C3,D2,D3...... are NOT available yet.

I want to see blank cell if C2,C3,D2,D3.....are not filled yet.

Any help would be appreciated

 

[JMay]

in c1 enter =IF(ISERROR(C2/C3),0,C2/C3)

 

[NYBoy]

NEVER MIND.......ISSUE RESOLVE

 

[AlfD]

Hi!

Or ensure there is something (even a space character) in the nex
cell?

Al