formula question and issue

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




0
kdoye2112 (29)
10/6/2004 11:01:29 PM
excel 39879 articles. 2 followers. Follow

7 Replies
431 Views

Similar Articles

[PageSpeed] 20

Bacchus wrote:
> 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
> 
> 
> 
> 
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
0
unavailable (273)
10/6/2004 11:15:45 PM
thanks...stupid me!!!

-- 
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/
"Alan Beban" <unavailable@no.com> wrote in message
news:%23c2Fnp$qEHA.3488@TK2MSFTNGP11.phx.gbl...
> Bacchus wrote:
> > 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
> >
> >
> >
> >
> 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


0
kdoye2112 (29)
10/6/2004 11:39:34 PM
wait a sec.

the answer is $1.79



-- 
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/
"Alan Beban" <unavailable@no.com> wrote in message
news:%23c2Fnp$qEHA.3488@TK2MSFTNGP11.phx.gbl...
> Bacchus wrote:
> > 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
> >
> >
> >
> >
> 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


0
kdoye2112 (29)
10/6/2004 11:42:12 PM
$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



"Alan Beban" <unavailable@no.com> wrote in message
news:%23c2Fnp$qEHA.3488@TK2MSFTNGP11.phx.gbl...
> Bacchus wrote:
> > 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
> >
> >
> >
> >
> 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


0
kdoye2112 (29)
10/6/2004 11:47:58 PM
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
-- 
Dana DeLouis
Win XP & Office 2003


"Bacchus" <kdoye2112@hotmail.com> wrote in message 
news:jcqdnUJOEb24GfncRVn-hg@rogers.com...
> $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
>
>
>
> "Alan Beban" <unavailable@no.com> wrote in message
> news:%23c2Fnp$qEHA.3488@TK2MSFTNGP11.phx.gbl...
>> Bacchus wrote:
>> > 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
>> >
>> >
>> >
>> >
>> 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
>
> 


0
delouis (422)
10/7/2004 12:04:03 AM
Your order of operations is hanging you up.

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

Which returns 1.79

Gord Dibben Excel MVP


On Wed, 6 Oct 2004 19:42:12 -0400, "Bacchus" <kdoye2112@hotmail.com> wrote:

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

0
Gord
10/7/2004 1:05:47 AM
Hmmm.  Must be a problem with Excel.  Seems that the calculator has
the same bug as well.  So does my pencil and paper.  :)

"Bacchus" <kdoye2112@hotmail.com> wrote in message news:<0rydnffvi-Ld5PncRVn-iw@rogers.com>...
> 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
0
ddawson (1)
10/7/2004 3:07:41 AM
Reply:

Similar Artilces:

help with formula please
new to this need help in a formula that will give me the percentage of two numbers. In other words a1=255 b1=8990.7c1=answer to question 255 is what percentage of 8990.7? =A1/B1 "TechnoGram" wrote: > new to this need help in a formula that will give me the percentage of > two numbers. In other words a1=255 b1=8990.7c1=answer to question 255 > is what percentage of 8990.7? > > How would you do it with plain ole math? -- Don Guillett SalesAid Software dguillett1@austin.rr.com "TechnoGram" <mumzee3@hotmail.com> wrote in message news:1181411910....

Pivot Table Question #12
I've created a pivot table and it works well - counts the number of items in each category. What it doesn't do is count the number of blank cells. It gives me a blank category but, alas, it is blank. I want the blank category line to tell me how many blank cells I have. I know that this is possible, but just can't seem to make it work. Can someone help? Thanks! To count the blanks you could use a space character, or the formula ="", in the source data, instead of leaving the cells blank. The pivot table will be able to count those. Betty Csehi wrote: > I&#...

General question re Error Handling
hello experts This is just a general question for my own education. I've dabbled in a fair amount of Access VBA in the past, but have just started learning about Excel VBA. In Access, we would use Error Handling in almost every sub, but In Excel, error Handling seems to be the exception rather than the rule. I can't even find much about it in the Excel VBA help, and there are relatively few references to it in this forum. What gives? Just Curious Terry W. Terry, I use it all the time. My favorite approach is: Public Const bDebug as boolean = true or false (de...

SMTP - ISP Question
Hi everyone, please accept my apologies in advance if this slightly off-topic but I though this would be a good place to ask... I am looking for some recommendations for a UK ISP who will register a domain (web hosting not terribly important) and will provide me with an SMTP feed. I have the connection and the public IP addresses already so I do not need a bundled service. Many thanks to all in advance, Kapa ...

'OR' formula error
I have this formula that produces an error in a column: =IF(OR((ROUND(N3,2)=ROUND(H3,2)), TRIM(H3)="$-"),"OK","ERROR!") Columns H and N are both currency. If they're equal it's supposed to display ok. If there is no value in H it's also supposed to show ok, otherwise create an error. The auditing steps look like this: =IF(OR((26.8=ROUND("$- ",2)), TRIM(H3)="$-"),"OK","ERROR!") =IF(OR((26.8=#VALUE!), TRIM(H3)="$-"),"OK","ERROR!") =IF(OR((#VALUE!), TRIM(H3)="$-"),"OK&q...

FORMULA USING MASTER QTY
have a 12 month period where i enter a master qty per month not to exceed 6 (ie 1.3 = 9 units) how do i sum the period and have excel calculate the formula. ns what would that formula be? todd, I don't know about anyone else but I don't follow what it is you are asking. Can you give more details and possibly a (text) example. -- Regards Sandy sandymann@mailinator.com Replace@mailinator with @tiscali.co.uk "todd" <todd@discussions.microsoft.com> wrote in message news:A1450E1A-1C25-48EA-A125-45AA529222C0@microsoft.com... > have a 12 month period where i enter...

Taskbar issues
Hello, I'm posting on behalf of someone else, who has a rather unusual problem with their Windows XP taskbar. He has somehow managed to move it to the top of the screen, and is unable to move it back, despite it being unlocked. I haven't been able to find any remedies for what he has done, was wondering if anyone could point us in the right direction?! Thanks in advance! ...

Exchange 5.5 sp4 - MAPI clients can not connect
We have an Exchange 5.5 server running on WIN2k O/S. It been running fine for a long time. Recently, users have been losing connection(s) to the store. Each time the store and all Exchange services are running properly and MAILBOX resources via the admin pull up successfully. The only remedy for our 100 + MAPI clients (only), is to restart the Exchange services, then, they can log back in... same issue will re-occur a day or two later. I'm suspecting something is screwing up RPC connections that prevent the MAPI users to get to their e-mail accts. STORE.EXE version is 5.5.2658.3...

Formula to copy related information from sheet 1 to sheet 2
Hello guys, I hope you'll can help me. i have the information below in sheet 1. i need the information to be filtered, copy and paste in sheet 2 according to the month. example. if october, i need all information for the month of october to be copy and past from column A, B, C sheet 1 to column A, B, C sheet 2 please help. A B C Serial Number Quantities (Kilos) Date 8.1122 539,470 22/10/2009 8.1122 403,697 22/10/2009 8.1122 643,710 05/11/2009 8.1122...

Compatiibility question
Hello Since I am going to college I qualify for the academic version of Publisher 2003. If I buy the academic version is this completely compatable with Publisher 2003? I anticipate sharing files with friends who have Publisher 2003. One other short question is when is a new version of Publisher coming out. Thanks Paul I was not aware of an Academic priced version of Publisher 2003. However, there is only one version available, so both will be 100% compatible. The next version of Publisher is due out October/November of 2006. -- Brian Kvalheim Microsoft Publisher MVP http://www....

a Solver question
Hi, I am trying to use Solver to solve a scheduling problem. We get orders every Sunday, and then schedule the production for the following week. The order is as follows: Prod1 Prod2 Prod3 M 4 1 T 1 W TR 2 1 F 1 SA S 2 The numbers indicate the amount of products we need produced BY this day. And we have schedule tables for two plants like this: Plant 1: Prod1 Prod2 Prod3 M x11 x12 T x21 x22 W x31 TR .... ... ...

Excel 2000 insists on typing a formula
I was sent a spreadsheet by a coworker that I want to edit. Specifically, I want to have two date columns, and a third that calculates the number of days between two dates. On a sheet I created from scratch, everything worked fine (format the dates, the "# of days" column formatted as a number). In this sheet nothing works. Every time I try to type a date, i.e. any number with a slash, it assumes I want to type a formula and adds an = sign and then calculates the date a 1/0/1900. It shows my most recently used formulas in the Name Box, which my other sheet doesn't do ...

Time formulae
Hi I use these formulae to insert the date and time in separate cells on a worksheet : A14 =TODAY() B14 =NOW()-TODAY() They update automatically when I open the sheet. It would be better however if they didn't do this until I use the Refresh All function. Is it possible to stop these functions updating until I need them to do so? I know I can switch global options off in the Options section of the program , but I'm loathe to do this for the sake of this one sheet. Grateful for any advice. ...

License Issues
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Loaded a second copy of Office for Mac 2008 on my wife's new Macbook. Thought this was OK as the EULA said I had 2 installs. Now getting an error if we are both online at home at the same time. This makes sense now that I better understand the terms of the EULA. I plan to buy Office 2008 Home & Student for my daughter who is off to college in the Fall. I could load a second copy of this on my wife's Mac, but will this wipe out all of the Entourage settings and contacts etc. on my wife's Mac? She just spe...

simple checkbox question
I really dont know much about VBA and/or macros and have what probably is an extremly basic question. I wasnt sure how to word it so when trying to search it i didnt really get any answers. all I want to do is add several checkboxes to a spreadsheet, if the user checks the box, I want the cell underneath it to be equal to 1, or any number or letter, it doesnt matter. i just used 1 in an IF formula but can change it if needed. what i am doing is a timesheet so that users can keep track of how many hours they worked each day, and if that day is a holiday, i want them to be able to use the ch...

Mo2004
Recently ( a few months ago) I started using MS Money 2004. Previously I had been managing finances on excel with formulas I had created. This was wroking great but someone suggested to switch to financial software to make things flow a bit easier. Since using Money 2004 I have had some struggles: #1 - My budget varies from month to month (who's doesn't?). Whenever I make changes to my budget it apears to retroactivly change all previous months. How can I get it to just change any given month? Along the same lines, can I make adjustments to prior months? #2 - At the end of...

HTTP and HTTPS sessions question
Some secure sites have HTTPS session stay secure from login till end of communication with site(log off). Some sites are HTTPS only when log in, after login, they become HTTP, and become HTTPS only when log off. (Yahoo mail for example, etc) What are the chances that session can be intercepted and sidejacked and traffic content recorded, especially as I know this danger really exists, and its carried purposefully and intentionally, by recording DSL traffic. http://www.google.com/search?hl=en&source=hp&q=session+hijacking+attack&aq=3&aqi=g10&aql=&oq=sess...

formulae for dates
below formulae =TODAY()-(LEFT(C1,2)*365.25)-((MID(C1,7+FIND("",MID(C1,7,99)),2))*365.25/12) gives an output is mm/dd/yy on entering 0 years x months but if I enter 0 years 10 months or 11 months it gives me wrong date e.g if entered 0 years 10 months it gives 31 april 2006 plz advise thanks Hi Gerald You are missing the space between the quotes in your formula Try =TODAY()-(LEFT(C1,2)*365.25)-((MID(C1,7+FIND(" ",MID(C1,7,99)),2))*365.25/12) -- Regards Roger Govier "Gerald" <Gerald@discussions.microsoft.com> wrote in message news:8CF4029E-2BAA...

Two identical formulas for a different result?
Hello everyone, :) A very quick question, but nonetheless very intriguing to me (I jus lost 4h on that :( ) I don't understand why my first formula works, and the second and thir don't. {=SUM(IF(FiscYear="2003",IF(IncomeFeeID="RB",Amount,0),0))} =SUMPRODUCT((FiscYear="2003")*(IncomeFeeID="RB")*Amount) (result is #value) =SUMPRODUCT((FiscYear="2003")*(IncomeFeeID="RB"),Amount) (this one could work too I thought, but result in a 0) I am simply trying to sum (amount) when the fiscal year is 2003 an IncomeFeeId is RB......

How do i select different cells to be use in a formula.
Hi I need to know how to select different cells to be used in a formula, but i don't know what is the separator that i need to use to this, see the example bellow Cells that i need to include on my formula: A1 C5 BH32 Thanks. Hi you didn't mention what formula but here's a starting point: =AVERAGE(A1,C5,BH32) or depending on your regional settings =AVERAGE(A1;C5;BH32) hope this helps Cheers JulieD "Manuel" <Manuel@discussions.microsoft.com> wrote in message news:A855A562-725C-4B10-B111-A88F7A767122@microsoft.com... > Hi > > I need to know ho...

Draging Formula
hi Please Please help me!!!!! I have a formula that relates to different sheets and cells in a sumary sheet. what i want to do is drag the cells and instead of the cell reference increasing i want the sheet reference to increase i.e. =Sheet2!A2 draged to; =Sheet3!A2 =Sheet4!A2 et thank you Daniel Daniel Entered in row 2 of a column. =INDIRECT("Sheet" & (ROW()) & "!A2") Gord Dibben Excel MVP On Sat, 31 Jan 2004 12:56:07 -0800, "Daniel Morgan" <Daniel1morgan@aol.com> wrote: >hi > >Please Please help me!!!!!! >I have a formula ...

Help with formula please.
Hi, I have the following formula set up on a sheet called 'Wow' =IF(Wow!A1="90 / 63 reducer", Wow!B1) What I would like to add (in plain speak) is if on Wow sheet, cell A1 says 90 / 75 reducer, enter B1 into sheet 4 cell A4. At the end of the day, what im after is the following: If on Wow sheet, cell A1 says '90 / 75 reducer', enter Wow sheet B1 figure into sheet 4 cell A20, but if on Wow sheet, cell A1 says 'sleeve', enter B1 figure into sheet 4 cell A50, but if on Wow sheet, cell A1 says 'outlet', enter B1 figure into sheet 4 cell A100. I hope ...

formula #9
I have A1 and A2, A1 has a value of 10, A2 has a value of 5. What is the formula for A3 to substract A1 from A2? A3(A1-A2) ? anyone? Hi =A2-A1 -- Regards Frank Kabel Frankfurt, Germany "Jack" <no@mail.com> schrieb im Newsbeitrag news:c4s8vr$rgr$1@news5.tilbu1.nb.home.nl... > I have A1 and A2, A1 has a value of 10, A2 has a value of 5. > > What is the formula for A3 to substract A1 from A2? > > A3(A1-A2) ? anyone? > > ...

Upgrade 7.5 to 9.0 possible issues
Hi! I'm working for clients who have GP 7.5 installed with SQL Server 2000. Few customization is done on it. They want to upgrade to 9.0 version. Could you please tell me if it's easy to perform upgrade or not? Possible issues? Also I haven't found any information about upgrading, please add links if available Thanks in advance. we're also in 7.5 just upgraded our test server with updated data to 9.0. had few bumps because I did some customizations and I knew where the problem occured. in your case, you have to know if the customizations will work on the new environ...

Help me with a formula please...
I need to create a formula that counts the number of cells that contain a keyword in one column and then further filters this down by month/year data from another column. Is there anyone out there who might be able to help me, if this is at all possible? Thanks!!!! Jon, I'm not sure I understand your question, but I think you might want a pivot table. It can be set to give you counts. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Jon" <jonathan.howe@comcast.net> wrote in message news:12C0AA23-4840-4D11-8...