Formula Lenght

[Stanman]

Hi,

I have the following formula applied to 1000 rows, the first row works fine returns a 1

=IF(OR(C2="",D2="",E2="",F2="",G2="",H2="",I2="",J2="",K2="",L2="",M2="",N2="",O2="",P2="",Q2="",R2="",S2="",T2="",U2="",V2="",W2="",X2="",Y2="",Z2="",AA2="",AB2="",AC2="",AD2=""),"*",1)

second and onwards it doesn't work?, returns * even when cells have value.

=IF(OR(C3="",D3="",E3="",F3="",G3="",H3="",I3="",J3="",K3="",L3="",M3="",N3="",O3="",P3="",Q3="",R3="",S3="",T3="",U3="",V3="",W3="",X3="",Y3="",Z3="",AA3="",AB3="",AC3="",AD3=""),"*",1)

I thought it was too long as I checked row 1000 to begin with but it actually falls over at row 3 onwards

 

[Peter_SSs]

Duplicate to: Ignoring formula when checking blank cells

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.