Forum Discussion
Emma Clark
Jan 24, 2018Copper Contributor
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...
Tinn Keeper
Mar 05, 2018Brass Contributor
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