I am trying to write a if statement for this situtation.
In cell A1 copy cell H1 (which is a date) if the number 1 appears in cell D1. But if there is a 0 or blank in cell D1 in the cell leave A1 blank.
Does anyone know how to write this IF statement?
Thanks in advance.