excel formula

[kunks1]

if a cell is empty enter the amount two cells to the right into a cell five cells to the right

[#2]

@kunks1 

Let's say the first cell you mention is A2.

Enter the following formula in F2 (i.e. 5 cells to the right):

=IF(A2="",C2,"")

[#3]

Thank you very much.