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 or O - depending upon the result.
For Example:
If the Value in Column C is equal to E then the value in N would be equal to the value shown in column J. The value in Column O would be 0.
and equally
If the Value in Column C is equal to I then the value in N would be 0 and the value in Column O would be equal to the value shown in column J.
I have attached a screen shot as well as the actual sheet - can anyone help me please ?
Apologies if it is such a basic question - I use excel but know it has many possibilities which I am trying to explore. Thank you so much Emma
- Tinn KeeperBrass 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