I am using two separate formula's to work out margin on a product but getting different answers.
Cost price is £302.50 To add 8.5% I am using =A4*(1+B4) where A4 is £302.50 and B4 is 8.5% - this gives me a sale price of £328.21
I then want to sanity check this by using the actual figures and...