If sales amount is in C2 and all the expenses are in column B, starting in
B2, use the formula

=B2/$c$2

and copy it down



"Dritz" wrote:

Does anyone know how I can enter a formular into an Excel Spreadsheet so that
I can show all the costs as a percentage of Sales please

There must be a way that one can drag the formula down the costs and show
each cost as a percentage of sales