Copying cells

[Jamieallen5]

I know that this may seem like a very basic question but it is really getting on my nerves.

if for instants I want to copy cell a1 by using =a1 it will obviously tell me what is in cell a1 but, if cell a1 is currently blank what would be the correct formula for me to put in so rather than it putting it as 0 it leaves it blank?

Thank you in advanced

 

[RoryA]

Hi, and welcome to the forum.

You can use:
=IF(A1="","",A1)

 

[Jamieallen5]

Rory, thank you very much for your help