1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to make excel subtract a cell based on the text of another cell?

Hello,

I have some cells that have 10% added to their total based on which item it is. I need to be able take the 10% based off the name of the item. So if 2,200 is the 10%, I need my cell to take 10% off and have it read 2,000 instead. I've tried IF and SUMIF, but I can't get it work it yet. I've messed around in the VBA but I fear that is beyond my current capabilities.

Any and all help is greatly appreciated!

submitted by /u/Few_Consequence3868
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article