ok..I have created a spreadsheet.
I need to work out..B4+.21/35*100 so...b4 cost is 17p and i need to add the value of c4 which in this example is 21p..then...sigh....work out what 65% of that total would be then....add on 17.5% vat to the 65% total price as a selling price. but i want to display the answer in c4.
God i am confusing myself here....sorry.
In summary, I want to start with a figure add another amount then get a figure of what 65% of that is then calculate adding 17.5% vat to the figure.
Thanks in advance
this is just an example, there are another maybe, 70 calculations on the page although all the same formula required.