Check if a cell has data ignoring the formula in it

[girapas]

I want to enter a formula in A2 to calculate A1+10, if the B2 has data and if it hasn't to leave the cell blank.
The cells B1 and B2 have formulas that update from other cell.
The following formulas don't work when I use them in A2 (I suppose due to the existence of the formula in B2):

=IF(B2="";"";A1+10)
=IF(B2=0;"";A1+10)
=IF(LEN(B2)=0;"";A1+10)
=IF(ISBLANK(B2);"";A1+10)

How can I resolve it, without using VBA?
Thanks in advance

 

[Scott Huish]

Can you post the formulas in B1 and B2?

 

[girapas]

The formulas in B1, B2 is like this:

=CONCATENATE(C1;" ";D1)

 

[Scott Huish]

That shouldn't have any affect on it. Although you don't really need CONCATENATE, this will do the same thing.

=C1&" " &D1

Excel Workbook
	A	B	C	D
1	10
2	20	a h	a	h
Sheet1

 

[girapas]

Although there isn't data in B2 (only the formula), it still put in A2 the A1+10 not blank!

 

[Scott Huish]

My cell B2 has a formula in it as well, based on what you said you had.

 

[girapas]

OK. I'll check if there's something else that affect it.
Thank you for your help!