CODEWITHSUNDEEP
excel
user1283776
user1283776

Reputation: 21814

The value 0 is not shown in a cell. Why?

I enter the formula:

=IF(OR(A3<>"";B3<>"";C3<>"";D3<>"";E3<>"";F3<>"";L3<>"";R3<>"";W3<>"";AB3<>"");ROW();0)

into a cell. Strangely the cell does not display the value 0, it displays nothing. However if I change the formula ti:

=IF(OR(A3<>"";B3<>"";C3<>"";D3<>"";E3<>"";F3<>"";L3<>"";R3<>"";W3<>"";AB3<>"");ROW();"0")

it displays a 0. Why doesn't it display a zero in the first case? I've checked the cell formating and it's "General". I can't think of what other could be causing this.

Upvotes: 1

Views: 287

Answers (2)

terrabit
terrabit

Reputation: 1

The formula is a bit wrong. It should be this way:

=IF(OR(A3<>"",B3<>"",C3<>"",D3<>"",E3<>"",F3<>"",L3<>"",R3<>"",W3<>"",AB3<>""),ROW(),0)

Replace (;)-semi-colon with (,)-comma. That should return (0) int value.

On the otherhand: 

=IF(OR(A3<>"",B3<>"",C3<>"",D3<>"",E3<>"",F3<>"",L3<>"",R3<>"",W3<>"",AB3<>""),ROW(),"0")

will return a (0) string value.

Upvotes: 0

gtwebb
gtwebb

Reputation: 3011

Under options>Advanced>Display options for the worksheet there is a check box for show a zero in cells that have zero value. Make sure this is checked for your worksheet.

Upvotes: 3

Related Questions