I'm new to building formulas and need some help. WHen I'm done building my formula the only thing that displays in the cell is the formula itself, not the results.
cell L2 contents: =IF(F2="",H2,F2)
what I'm attempting to do:
if F2 is has no data, copy the contents of cell H2 into cell L2
if cell F2 has data, copy the contents of cell F2 into cell L2
according to what I've read this formula should work. But when I hit <return> after the ), nothing happens. The contents of cell L2 shows my formula.
I hope I'm explaining this correctly. THanks
cell L2 contents: =IF(F2="",H2,F2)
what I'm attempting to do:
if F2 is has no data, copy the contents of cell H2 into cell L2
if cell F2 has data, copy the contents of cell F2 into cell L2
according to what I've read this formula should work. But when I hit <return> after the ), nothing happens. The contents of cell L2 shows my formula.
I hope I'm explaining this correctly. THanks