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


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

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



Thank you very much.