Help with three calculation in one cell

Hello,

I really apologize if this is a re-post, I have a problem I have been fighting with for two days now, and I have read and searched but cannot seem to find the exact answer I need for my situation.

I am trying to figure out how to multiply a set of number from two different cells (B2*B3) then add a set of numbers from two different cells (B1+B5)and add the results from those two together(650+898), then multiply another set of cells (B2*B4)take the end results from both previous actions and subtract them from one another (1548-2799)and finally divide that answer(1251/2799)by the result from the last to cells that were multiplied. This reads very confusing so I hope the illustration helps. Thanks in advance.


B2*B3 = 650
B1+B5 = 898

Total: 1548

Then
B2*B4 = 2799-1548

= 1251


Lastly: 1251/2799

Answer: 45%


Thanks again

Try this:

=((B2*B4)-(B2*B3+B1+B5))/(B2*B4)

Format the cell as %age.

Hope this helps.

Pete

Thanks Pete!! that worked great! I tried placing this formula in a user form i created and i am getting a "Variable not defined" error highlighting the MOQ in the first line of code would you have any idea why i'm getting this error?

Option Explicit
Private Sub CalculateButton_Click()
WithFee = ((MOQ * Retail) - (MOQ * Price + Fee + Shp) / (MOQ * Retail))
NoFee = ((MOQ * Retail) - (MOQ * Price + Shp) / (MOQ * Retail))

End Sub
Private Sub CloseFormButton3_Click()
CheckProduct.Hide

End Sub

Private Sub ResetButton_Click()
Unload CheckProduct
CheckProduct.Show

End Sub

Private Sub txtWithFee_Change()

End Sub

Well, what is MOQ (or Retail, Fee, Shp for that matter)?

Pete

Originally Posted by Pete_UK

Well, what is MOQ (or Retail, Fee, Shp for that matter)?

Pete

That is just the names of the txt boxes that the data is entered into on the userform.