[Solved] Help with formula

[FxDelusions]

Good day all! New user here, and trying to figure out how to get a formula to correctly work with Calc. This is what I am trying to do, with all the information that I can provide:
-add 2 cells together
-subtract 2% from the total of the 2 cells
-subtract .30

this is what ive come up with, but I am not getting the right answer
Values are as follows: C2 = $7.00, H2 = $4.55, Percent to deduct is 2%, change to deduct .30 cents
what Ive come up with on paper:
(4.00+7.55)-2%)-.30
The total is 11.019 or $11.02
However, when i try that formula in Calc, it changes it too
=(D2+H2)-0.02-0.3
and gives me an answer of:
$11.23, which is really wrong

I cant wrap my head around it. Ive tried moving numbers around, but i keep getting the wrong answers.

Any help with this would be greatly appreciated!
Thank you all for your time!

~Nelson

[RoryOF]

The 2% is being treated as 0.02; Calc can't read your mind and doesn't know that you mean 2% of the sum, You should calculate 2% of the sum and deduct that.

[FxDelusions]

Thank you kindly for the reply! How would I go about doing that exactly? I'll explain why the numbers. I am making a list of inventory, and want to have wholesale pricing, plus the item mark up. With the retail pricing though, the company that will be selling our products take a 2% cut per transaction, on top of a .30 cent fee for each transaction. So the numbers I have provided, is a whole sale cost $7.00 that i increased by 65%, which is $4.55. So that gives me $11.55 as a final price. It is this price that the 2% percent is taken out, and then the .30 cents to be deducted, in that order. Thank you once again for the reply!

[Lupp]

Code: Select all

=(A1+B1)*0.98-30

where A1 and B1 are references to the two cells you first want to add the values of. 0.98 is short for (100% - 2%).

[FxDelusions]

Thank you SOOO MUCCHH!!!! This is EXACTLY what I was looking for! I really appreciate the help on this issue This formula works like a charm!

Thank you very much, once again!
~Nelson