Hello,
I am trying to do a calculation whereby the sum of two cells would be affected by a word in another cell.
For example, "=I10-G20" let's say equals $50.00. Then if a cell on the same line has the word "hello" I want to minus a fee that the word "hello" imposes on the sum I calculated. So I am trying to subtract a say, $0.0000221 from the sum that =I10-G20 calculated if the word "hello" is in cell N.
Any idea how to do this?
Bookmarks