Polynomial Equation?

[Eugene020202]

I'm working on a price sheet where one of our dealers gets a different price based on a couple of adders. The formula is simply:

(Their Cost) + (2% of Their Cost) + (6% of Their Cost) = (Our Cost)

For example:

$7.00 + $0.14 + $0.42 = $7.56

The problem is that Their Cost is the unknown, but the percentages are based on that unknown amount. I was able to find Their Cost using Goal Seeker, but I don't want to have to go through that process each time I need to find Their Cost for a new product. I'll always know what Our Cost is, of course.

Is there a function that will determine what number needs to be in the cell for Their Cost so that when the percentages are added, you arrive at Our Cost?

Thanks in advance.

[MrShorty]

Unless I missed something, this should come down to simple algebra:

x+0.02*x+0.06*x=1.08*x=y
x=y/1.08

[Eugene020202]

Thanks. Duh. It seems to be working.