How do I take a percentage off cells that contain a certain word?
So I wish to enter lets say 10% in the red box and a word in the other box (bubble) so it only takes percentages off that word I enter.
I've worked out the percentage but need to only take this off when containing the word bubble.
Hope it makes sense!
Bookmarks