formula question and issue

  • Thread starter Thread starter Bacchus
  • Start date Start date
B

Bacchus

Hi,

When I type this formula in Excel it gives me the wrong amount.

=SUM(H1257)*(5.25%)+(0.6)*1.27 - H1257 = $15.50

It gives me the answer to be $1.58 which is wrong.

The clear answer is truly $1.79

Is there something wrong with my formula or is there an adjustment I need to
make with the software itself. This is frustrating the heck outof me. Why
can't Excel give the correct answer of $1.79?

thanks
 
Bacchus said:
Hi,

When I type this formula in Excel it gives me the wrong amount.

=SUM(H1257)*(5.25%)+(0.6)*1.27 - H1257 = $15.50

It gives me the answer to be $1.58 which is wrong.

The clear answer is truly $1.79

Is there something wrong with my formula or is there an adjustment I need to
make with the software itself. This is frustrating the heck outof me. Why
can't Excel give the correct answer of $1.79?

thanks
Click to expand...
Assuming that the 1.27 is actually $1.27, the correct answer is $1.57575.

$15.50 x 5.25% is $0.762; $1.27 x .6 is $0.81375

$0.762 + $0.81375 = $1.57575

Alan Beban
 
$15.50 x 5.25% = 0.81375

0.81375 + 0.60 = 1.41375

1.41375 x 1.27 = 1.7954625

This is how I calculate my Ebay fees and it maches up with them. I want to
implment this in my spreadhseet so I do not have to calulate it every time
but it does not seem to match up with Ebay or myself. It gives me $1.58 for
some reason. I just need the right formuls to put in.

thanks
 
If cell H1257 has the value 15.5, then the formula

=(H1257*5.25%+0.6)*1.27

returns
1.79

Don't know if this is it though.
HTH
 
Your order of operations is hanging you up.

Try =(H1257*5.25%+0.6)*1.27

Which returns 1.79

Gord Dibben Excel MVP
 
Hmmm. Must be a problem with Excel. Seems that the calculator has
the same bug as well. So does my pencil and paper. :)
 
Back
Top