Formula Help

Question

I am creating a spreadsheet for my job. I need to set up a formula that if the specified cell = the word "Add," it will add two different cells together, as well as if it ="Delete", it will subtract said cells.... is there a way to do that? If so, can someone help me out with that?&nbsp;&nbsp;Example of what I am trying to accomplish: If F2="Add" then Cell N3= C3+M3&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; If F2="Delete" then Cell N3=M3-C3&nbsp;

tauqeeracma · Answer

Hi&nbsp;tinabthatsme&nbsp;&nbsp;Please try below formula&nbsp;=IF(F1="Add",C1+M1,IF(F1="Delete",M1-C1,""))&nbsp;Sample file is also attached for your reference.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

preagan · Answer

Hello&nbsp;tinabthatsme,&nbsp;It appears that you have just about figured the formula out yourself!In formulaic form, what you described in cell N3 would be:=If(F2="Add", C3+M3, If(F2="Delete","M3-C3,""))&nbsp;Hope this helps!PReagan

tinabthatsme · Answer

Thank you! I didn't add the appropriate "" in the formula which is why I couldn't get it to work, so thank you!

tinabthatsme · Answer

Perfect! Thanks!

Forum Discussion

Formula Help

4 Replies