Forum Discussion
IF Formula for excel
Hi
I am trying to use an IF Statement (not sure if this is correct).
I want to put either an I or E in Column C - resulting in data being pulled from Column J and being placed in either Column N...
Hi Emma,
Probably quite late with this response, but here the solution for your calculation.
In column N, use =IF(C3="E",J3,0)
In column O, use =IF(C3="E";0;J3)
Enclosed your file, with the formula in it.
Kr
TK