I need you help on a formula.
If you look at my excel sheet, in Range("I10"), i have the total money available.
In column E, i have the Gift card value and In column G, this is where i will put Yes, every time that i give a card.
Finally, in Column I is the Money available left after giving a card.
I need to deduct from the Money available Range("I10") every time that i put yes in column G, the value from the same lane in column E.
How can i do this please?
Thanks for your help.