Forum Discussion
tinabthatsme
Aug 28, 2019Copper Contributor
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 ...
tauqeeracma
Aug 28, 2019Steel Contributor
Hi tinabthatsme
Please try below formula
=IF(F1="Add",C1+M1,IF(F1="Delete",M1-C1,""))
Sample file is also attached for your reference.
- tinabthatsmeAug 28, 2019Copper Contributor
Perfect! Thanks!