Aug 28 2019 09:53 AM
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?
Example of what I am trying to accomplish: If F2="Add" then Cell N3= C3+M3
If F2="Delete" then Cell N3=M3-C3
Aug 28 2019 10:05 AM
Please try below formula
=IF(F1="Add",C1+M1,IF(F1="Delete",M1-C1,""))
Sample file is also attached for your reference.
Aug 28 2019 10:07 AM
Hello @tinabthatsme,
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,""))
Hope this helps!
PReagan
Aug 28 2019 10:17 AM