Hi guys,

Apologies if something similar has been posted before, if had a hunt through some of the older posts but haven't spotted anything.

Basically my problem is that I have 2 kinds prices in a spreadsheet. A default one for standard products, additional option price which either adds or remove a value if the product comes in black or large etc.

My stores under a sale now so I need to remove 25% from all the prices and the additional option prices are causing me difficulties.

e.g.
Price:
321
3950
[ADD]759.6
[ADD]1520.4
[REMOVE]1.2

Its the words ADD and REMOVE that throwing me. For the first two defaults I imputed =CELL/100*75. But this doesn't work with the cells with words in them.

Any ideas? Thanks in advance
Amy