Help with a formula

[Chuck Echeese]

I am an artist, so this is not the side of my brain that works all that well. I am trying though. I need a formula that I almost got, but i'm stuck, and would greatly appreciate any help. I realize that most can do this in their sleep, but not me.

I need to calculate the price of gold and casting for any given day. (the price of gold will be "X")

The first cell would be the price of gold per ounce. ("X")

The second cell would give me a formula that I need, here it is. X+5/31.1=/1.33 ("X" plus 5 divided by 31.1, then that sum then divided by 1.33. I can do the formula until I get to the /1.33 portion. I can't figure out how to have the sum, then have it divided by 1.33.

Then to top it off, I need to add "Y" (an additional charge per gram) to the total.

Thanks in advance

 

[CWatts]

Gold may not rust, but my gold pricing is a bit rusty. (So are my puns.) I'm not too certain about the math -- could you clarify?

Which are you trying to get?

x+5                     5
------   or      x +  -----           
31.1                  31.1

I'm going to assume the first one, and then divide that result by the 1.33.

=(B1+5)/31.1/1.33

As for the surcharge Y, what do you want to multiply it against?

 

[Chuck Echeese]

Ah, the pun, since you are responding, and helpful, I am appreciative!

Yes, the first calculation.

The surcharge. My brain is in a freeze right now. It is to be multiplied by the result that i get with your formula.

Just so that i understand, I need to put the first part of the equation in parenthesis, which gives me that total, then proceed with nay further calculations?

Thank you sooooo much!!!

 

[CWatts]

Right. Mathematically, it's called order of operations, which means that multiplication and division are performed first, and then addition and subtraction afterward.

So given 5 + 2 * 4, if you just left it that way, the result would be 13. If you wanted to force it to do the addition before the multiplication (like you wanted with the x + 5), then it's placed in parentheses like this: (5 + 2) * 4.

As for the surcharge, if you put the value of the surcharge in B2, then you can use:

=(B1+5)/31.1/1.33*B2

 

[Chuck Echeese]

Now i do understand. You have helped tremendously. Again, thank you so much!