Forum Discussion

Emma Clark's avatar
Emma Clark
Copper Contributor
Jan 24, 2018

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 Keeper's avatar
    Tinn Keeper
    Brass 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

Resources