Copy and paste using =if forumula

[Jeff M]

I have a large spreadsheet that has 3 columns - A, B and C. Some of the rows in column C are blank and others are not. How do I use the =if formula to say if C6500 is blank, use A6500? If C6500 is not blank, use what is existing in C6500.

Thanks,
Jeff

[oldchippy]

Hi,

Try this

=IF(C6500="",A6500,C6500)