I am trying to produce a spread sheet to calculate gross profit including VAT at 20%

example purchase price ex vat £1.50 profit margin at 45% = selling price

the spread sheet then needs a range fron £1 to £2 and 40% to 50%

Regards
Martin