Apr 19 2021 09:45 AM
if a cell is empty enter the amount two cells to the right into a cell five cells to the right
Apr 19 2021 09:54 AM
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,"")