Trying to calculate Profit from 2 cells containing existing formulas

**LiveOnLocation** · 11-05-2012, 01:02 PM

Good Morning,

I am a fairly beginner user, but have got myself in over my head on a cost/margin spreadsheet I created.
I am running Excel 2007 on a XP machine.

I'd love to attach a chunk of my spreadsheet to show you what I'm trying to do, but I'll start by describing my issues:

Cell F3 is a sum equalling Total cost (E3+C3+B3)

Cell G3 is Sell Price, calculated from =F3/((-(H$1)+100)/100) where H$1 represents a user selected profit margin

I then have H3 which is the Profit Margin with the following formula: =(G3-F3)/G3 formatted as a percentage

I would like H3 to represent the calculated value from G3 & F3 and not the user selected margin in H$1

I hope that someone can help me with this, like I said I think I'm a little over my head.

Cheers

**LiveOnLocation** · 11-05-2012, 01:08 PM

here's more info on what I am trying to do:

I would like B3 to also be a number that I can change, when I change the value of B3, it changes F3 (total cost) and then changes G3 the Sell price.

I would like H3 to reflect the change in the sell price in the margin as well, instead of defaulting to the user selected margin from H$1.

I hope that makes more sense...

https://www.dropbox.com/sh/34auovyha...yAH/Book2.xlsx