excel formula

New Contributor

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

2 Replies

@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,"")

Thank you very much.