So I thought I was getting a grasp on this formula stuff, or maybe just not enough coffe, but I have a formula that I want to equal a cell value, but if the cell value = #N/A then it needs to return a G. This is what I have and cant figure out why it wont work.
=D2 IF(D2="#N/A","G", " ")
So I am wanting it to retain cell D2 value unless D2 is #N/A, then it should return a G.
What am I missing.
I am putting the formula in D3.
=D2 IF(D2="#N/A","G", " ")
So I am wanting it to retain cell D2 value unless D2 is #N/A, then it should return a G.
What am I missing.
I am putting the formula in D3.