If Cell is Empty

[cafc_fuller]

Hello there,

I have a copy function so all Cells on my Customer form F(8,9,10,11,12,13) all equal F(8,9,10,11,12,13) on the Despatch sheet
So when I type it in this box it appears the same on the Despatch sheet and this works fine.

Howver if F11 is empty on Customer I want the F(8,9,10,11,12,13) on the despatch sheet to equal the values of A(8,9,10,11,12,13) on the customer sheet.

Is their an IF statment to do this?
If you need me to upload an example please let me know.

Thanks for all your help.

Darren

[kbkumar]

Would be helpful if you could upload a sample file...

[Deventus]

Hi
This should hopefully work

=IF(ISBLANK(F11),F8+F9)

Adi

[cafc_fuller]

Its attached - that formula did not work. I have put it in to show you that on the despatch sheet even though it is blank the value is still the same as the Despatch address on the customer sheet.

If you need me to explain this please let me know....

Thanks
Darren

[cafc_fuller]

Just to explain it clearer if F11 is blank on customer i want the Despatch Sheet cells F(8,9,10,11,12,13) to equal A(8,9,10,11,12,13) on the customer sheet.

Thanks
Darren

[Pepe Le Mokko]

Before solutions can be found, it might be best if you removed the may merged cells you are using. They are nothing but trouble

[cafc_fuller]

Ok i can do this if its not possible with merged cells.

Thanks
Darren

[JosephP]

on despatch sheet
=IF(Customer!$F$11="",Customer!A8,Customer!F8)
and fill down

[cafc_fuller]

Perfect! Thank you