% profitability spreadsheet

[Val1646]

Can you help me please?

I am doing a spreadsheet of job profitability

I have three colums
ACTUAL INVOICE PROFIT %
280 580 300 ?

How do I the gross margin profit as a percentage ? What is the forumula please?

 

[Frank Kabel]

Hi
try
=C1/B1
and format this resulting cell as percentage

 

[Val]

Many thanks Frank
I was trying to make it more complicated !
much appreciated
regards Val UK

 

[alexandra]

Can you help me please?

I want to create a invoice and i dont now ?