formula question and issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bacchus - 07 Oct 2004 00:01 GMT

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

Reply to this Message

Alan Beban - 07 Oct 2004 00:15 GMT

> Hi,
>
[quoted text clipped - 11 lines]
>
> thanks

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

Reply to this Message

Bacchus - 07 Oct 2004 00:39 GMT

thanks...stupid me!!!

Signature

Kevin Oye
Oye's Outlet
Toronto, Ontario, Canada
(647) 272-3057
http://stores.ebay.ca/Oyes-Outlet
oyesoutlet@rogers.com
http://oyesoutlet-inventory.blogspot.com/

> > Hi,
> >
[quoted text clipped - 19 lines]
>
> Alan Beban

Reply to this Message

Bacchus - 07 Oct 2004 00:42 GMT

wait a sec.

the answer is $1.79

Signature

Kevin Oye
Oye's Outlet
Toronto, Ontario, Canada
(647) 272-3057
http://stores.ebay.ca/Oyes-Outlet
oyesoutlet@rogers.com
http://oyesoutlet-inventory.blogspot.com/

> > Hi,
> >
[quoted text clipped - 19 lines]
>
> Alan Beban

Reply to this Message

Gord Dibben - 07 Oct 2004 02:05 GMT

Your order of operations is hanging you up.

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

Which returns 1.79

Gord Dibben Excel MVP

>wait a sec.
>
>the answer is $1.79

Reply to this Message

Bacchus - 07 Oct 2004 00:47 GMT

$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

> > Hi,
> >
[quoted text clipped - 19 lines]
>
> Alan Beban

Reply to this Message

Dana DeLouis - 07 Oct 2004 01:04 GMT

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

Signature

Dana DeLouis
Win XP & Office 2003

> $15.50 x 5.25% = 0.81375
>
[quoted text clipped - 36 lines]
>>
>> Alan Beban

Reply to this Message

David Dawson - 07 Oct 2004 04:07 GMT

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

> Hi,
>
[quoted text clipped - 11 lines]
>
> thanks

Reply to this Message