IF Formula for excel

[Emma Clark]

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

[#2]

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