Ignoring formula when checking blank cells

[Stanman]

Hi,
I have a formula that checks if the cell is blank and returns a value but its picking up the formula as a value, is there anyway to ignore it?

 

[steve the fish]

Try:

=IF(A1="","Return This","Return That")

It always helpful if you had provided the formula you was trying

 

[Stanman]

Sorry my mistake,
the formula is =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)

The cells being checked have a formula to pull the data from elsewhere and that is causing the issue. For example D3 as a formula in it =Sheet1!C10

 

[steve the fish]

Ok what is in Sheet1 cell C10?

 

[Stanman]

its blank at the moment but will be text value when completed

 

[Peter_SSs]

D3 as a formula in it =Sheet1!C10

what is in Sheet1 cell C10?

its blank at the moment but will be text value when completed

Does that mean that D3 is showing a 0?

 

[Stanman]

Hi Peter_SS,
D3 isnt showing any value, it just has the formula in it Sheet1!C10, and sheet 1 c10 has not value in it, if you click in it shows formula

 

[Peter_SSs]

If you put this in an empty cell, what does it return?
=LEN(D3)

 

[Peter_SSs]

Better still, why not give us a few rows of the sheet with XL2BB? Then we can see the formulas and their results and also copy to our sheets for testing.

 

[Stanman]

Thank you all. Its work laptop and they wont let us install any addon etc.
I will recreate it later on personal and post up XL2BB.

The Len returns 1, if I take the formula out of the cell the cell it returns 0