Need Help with Cost and Sales Percentage

[Ferdinand Gabriel]

Hello, I need help calculating the costs, given the sales and percentage of sales, and the sales, given the costs and percentage of costs. I also need assistance on determining the cost percentage given the costs and sales. Kindly find attached the image of a section of the excel worksheet.
A formula alone is enough.

TIA

 

[Fidget]

Tell you what.. you tell me how you would calculate the answers to this without excel, and I'll tell you the excel formula that will do it. Deal?

 

[Ferdinand Gabriel]

Hey, thanks for the response. I need the excel formula

 

[Fidget]

No probs! I just need you to tell me how to do the calculation, you know - as if you had to write it down on a piece of paper, and then I'll be able to tell you how to get excel to do it.