Forum Discussion
Formula Help
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 ...
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
Thank you! I didn't add the appropriate "" in the formula which is why I couldn't get it to work, so thank you!