Guest Dragon Posted September 26, 2007 Posted September 26, 2007 I am missing some logic here, so please explain if it makes any sense to you... Using Windows Calculator Press the following buttons: 480000 / 35% = And you get the result: 168000 When infact your result should be: 1371428.57xxxxx What Gives?
Guest PA Bear Posted September 26, 2007 Posted September 26, 2007 Re: Don't know how to use a calculator... Are you trying to determine 35% of 480000? Dragon wrote: > I am missing some logic here, so please explain if it makes any sense to > you... > > Using Windows Calculator Press the following buttons: > > 480000 / 35% = > > And you get the result: 168000 > > When infact your result should be: 1371428.57xxxxx > > What Gives?
Guest John John Posted September 26, 2007 Posted September 26, 2007 Re: Don't know how to use a calculator... Put it in scientific mode or break it down to lower forms and use the memory functions 480000/(35/100) or 480000/.35 or 35/100= (Use M+ to store the above .35 return to memory, them press CE to clear the display) then 480000/MR= John Dragon wrote: > I am missing some logic here, so please explain if it makes any sense to > you... > > Using Windows Calculator Press the following buttons: > > 480000 / 35% = > > And you get the result: 168000 > > When infact your result should be: 1371428.57xxxxx > > What Gives? > >
Guest Dragon Posted September 26, 2007 Posted September 26, 2007 Re: Don't know how to use a calculator... I know I can break it down and it works. But I want to know is this a bug in Win Calc? "John John" <audetweld@nbnet.nb.ca> wrote in message news:OHu7L8IAIHA.4828@TK2MSFTNGP04.phx.gbl... > Put it in scientific mode or break it down to lower forms and use the > memory functions > > 480000/(35/100) > > or > > 480000/.35 > > or > > 35/100= > > (Use M+ to store the above .35 return to memory, them press CE to clear > the display) > > then > > 480000/MR= > > > John > > Dragon wrote: > >> I am missing some logic here, so please explain if it makes any sense to >> you... >> >> Using Windows Calculator Press the following buttons: >> >> 480000 / 35% = >> >> And you get the result: 168000 >> >> When infact your result should be: 1371428.57xxxxx >> >> What Gives?
Guest Dragon Posted September 26, 2007 Posted September 26, 2007 Re: Don't know how to use a calculator... No. I am trying to devide 480000 by 35% (480000 / (35%) or 480000/35*100. Just trying to find out if there is a bug in Win Calc. "PA Bear" <PABearMVP@gmail.com> wrote in message news:OSatF5IAIHA.968@TK2MSFTNGP03.phx.gbl... > Are you trying to determine 35% of 480000? > > Dragon wrote: >> I am missing some logic here, so please explain if it makes any sense to >> you... >> >> Using Windows Calculator Press the following buttons: >> >> 480000 / 35% = >> >> And you get the result: 168000 >> >> When infact your result should be: 1371428.57xxxxx >> >> What Gives?
Guest Elmo Posted September 26, 2007 Posted September 26, 2007 Re: Don't know how to use a calculator... Dragon wrote: > No. I am trying to devide 480000 by 35% (480000 / (35%) or 480000/35*100. > Just trying to find out if there is a bug in Win Calc. > > > "PA Bear" <PABearMVP@gmail.com> wrote in message > news:OSatF5IAIHA.968@TK2MSFTNGP03.phx.gbl... >> Are you trying to determine 35% of 480000? >> >> Dragon wrote: >>> I am missing some logic here, so please explain if it makes any sense to >>> you... >>> >>> Using Windows Calculator Press the following buttons: >>> >>> 480000 / 35% = >>> >>> And you get the result: 168000 >>> >>> When in fact your result should be: 1371428.57xxxxx >>> >>> What Gives? That would take a parenthetical expression. (I think that's the term..) I doubt it's possible without a scientific calculator. BTW, any number, divided by 35% of itself would give you 2.857xxx You should get that number by clicking 480000/35%= or 50/35%= hth, not trying to be a bore, nor a boor.. -- Joe =o)
Guest Dragon Posted September 26, 2007 Posted September 26, 2007 Re: Don't know how to use a calculator... hmmm, This is strange. I just picked up a $1 calculator and performed the same calculation with correct results. I also tested it in Excel by entering formula (=480000/35%) and received the correct results. To me (=480000/35%) = (480000) * (1/35 ) * (100) Where is that number (2.587xxx) coming from? Is Calc applying some different logic? "Elmo" <elmogeek@iglou.invalid> wrote in message news:O3sp8SJAIHA.5164@TK2MSFTNGP05.phx.gbl... > Dragon wrote: >> No. I am trying to devide 480000 by 35% (480000 / (35%) or 480000/35*100. >> Just trying to find out if there is a bug in Win Calc. >> >> >> "PA Bear" <PABearMVP@gmail.com> wrote in message >> news:OSatF5IAIHA.968@TK2MSFTNGP03.phx.gbl... >>> Are you trying to determine 35% of 480000? >>> >>> Dragon wrote: >>>> I am missing some logic here, so please explain if it makes any sense >>>> to >>>> you... >>>> >>>> Using Windows Calculator Press the following buttons: >>>> >>>> 480000 / 35% = >>>> >>>> And you get the result: 168000 >>>> >>>> When in fact your result should be: 1371428.57xxxxx >>>> >>>> What Gives? > > That would take a parenthetical expression. (I think that's the term..) I > doubt it's possible without a scientific calculator. > > BTW, any number, divided by 35% of itself would give you 2.857xxx You > should get that number by clicking 480000/35%= or 50/35%= > > hth, not trying to be a bore, nor a boor.. > > -- > Joe =o)
Guest Sinner Posted September 26, 2007 Posted September 26, 2007 Re: Don't know how to use a calculator... "Dragon" <noSpam_baadil@hotmail.com> wrote in message news:OaXEcGJAIHA.4752@TK2MSFTNGP04.phx.gbl... > No. I am trying to devide 480000 by 35% (480000 / (35%) or 480000/35*100. > Just trying to find out if there is a bug in Win Calc. > > The problem is the logic. 36% is a ratio, 35/100*X. It isn't a real number. 480000 can be divided by X, or 35%X, but not by 35%.
Guest Dragon Posted September 26, 2007 Posted September 26, 2007 Re: Don't know how to use a calculator... I get what you are saying. It makes sense. Having said that, which one is wrong (Excel and $1 calculator or Win Calc)? "Sinner" <sinner@gatesofhell.org> wrote in message news:KaCKi.104564$jH3.61007@bignews6.bellsouth.net... > > "Dragon" <noSpam_baadil@hotmail.com> wrote in message > news:OaXEcGJAIHA.4752@TK2MSFTNGP04.phx.gbl... >> No. I am trying to devide 480000 by 35% (480000 / (35%) or 480000/35*100. >> Just trying to find out if there is a bug in Win Calc. >> >> > > > The problem is the logic. 36% is a ratio, 35/100*X. It isn't a real > number. > > 480000 can be divided by X, or 35%X, but not by 35%. >
Guest NoConsequence Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... On Wed, 26 Sep 2007 16:02:46 -0700, "Dragon" <noSpam_baadil@hotmail.com> wrote: >I know I can break it down and it works. But I want to know is this a bug in >Win Calc? > > >"John John" <audetweld@nbnet.nb.ca> wrote in message >news:OHu7L8IAIHA.4828@TK2MSFTNGP04.phx.gbl... >> Put it in scientific mode or break it down to lower forms and use the >> memory functions >> >> 480000/(35/100) >> >> or >> >> 480000/.35 >> >> or >> >> 35/100= >> >> (Use M+ to store the above .35 return to memory, them press CE to clear >> the display) >> >> then >> >> 480000/MR= >> >> >> John >> >> Dragon wrote: >> >>> I am missing some logic here, so please explain if it makes any sense to >>> you... >>> >>> Using Windows Calculator Press the following buttons: >>> >>> 480000 / 35% = >>> >>> And you get the result: 168000 >>> >>> When infact your result should be: 1371428.57xxxxx >>> >>> What Gives? > No, it's a problem with what you are trying to do. Are you trying to divide by .35? Or 35%? If the latter, then here's the problem: 35% of WHAT? If you aren't clear, why would expect the calculator give you the answer you were looking for? It appears it is giving you what 35% or 480,000 is.
Guest Elmo Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... Dragon wrote: > hmmm, This is strange. I just picked up a $1 calculator and performed the > same calculation with correct results. I also tested it in Excel by entering > formula (=480000/35%) and received the correct results. > > To me (=480000/35%) = (480000) * (1/35 ) * (100) > > Where is that number (2.587xxx) coming from? Is Calc applying some different > logic? > > > "Elmo" <elmogeek@iglou.invalid> wrote in message > news:O3sp8SJAIHA.5164@TK2MSFTNGP05.phx.gbl... >> Dragon wrote: >>> No. I am trying to devide 480000 by 35% (480000 / (35%) or 480000/35*100. >>> Just trying to find out if there is a bug in Win Calc. >>> >>> >>> "PA Bear" <PABearMVP@gmail.com> wrote in message >>> news:OSatF5IAIHA.968@TK2MSFTNGP03.phx.gbl... >>>> Are you trying to determine 35% of 480000? >>>> >>>> Dragon wrote: >>>>> I am missing some logic here, so please explain if it makes any sense >>>>> to >>>>> you... >>>>> >>>>> Using Windows Calculator Press the following buttons: >>>>> >>>>> 480000 / 35% = >>>>> >>>>> And you get the result: 168000 >>>>> >>>>> When in fact your result should be: 1371428.57xxxxx >>>>> >>>>> What Gives? >> That would take a parenthetical expression. (I think that's the term..) I >> doubt it's possible without a scientific calculator. >> >> BTW, any number, divided by 35% of itself would give you 2.857xxx You >> should get that number by clicking 480000/35%= or 50/35%= >> >> hth, not trying to be a bore, nor a boor.. 480000 / (35% [of 480000 which is 168000]) = 2.8xx That actually looks right to me.. -- Joe =o)
Guest John John Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... Elmo wrote: > Dragon wrote: > >> hmmm, This is strange. I just picked up a $1 calculator and performed >> the same calculation with correct results. I also tested it in Excel >> by entering formula (=480000/35%) and received the correct results. >> >> To me (=480000/35%) = (480000) * (1/35 ) * (100) >> >> Where is that number (2.587xxx) coming from? Is Calc applying some >> different logic? >> >> >> "Elmo" <elmogeek@iglou.invalid> wrote in message >> news:O3sp8SJAIHA.5164@TK2MSFTNGP05.phx.gbl... >> >>> Dragon wrote: >>> >>>> No. I am trying to devide 480000 by 35% (480000 / (35%) or >>>> 480000/35*100. Just trying to find out if there is a bug in Win Calc. >>>> >>>> >>>> "PA Bear" <PABearMVP@gmail.com> wrote in message >>>> news:OSatF5IAIHA.968@TK2MSFTNGP03.phx.gbl... >>>> >>>>> Are you trying to determine 35% of 480000? >>>>> >>>>> Dragon wrote: >>>>> >>>>>> I am missing some logic here, so please explain if it makes any >>>>>> sense to >>>>>> you... >>>>>> >>>>>> Using Windows Calculator Press the following buttons: >>>>>> >>>>>> 480000 / 35% = >>>>>> >>>>>> And you get the result: 168000 >>>>>> >>>>>> When in fact your result should be: 1371428.57xxxxx >>>>>> >>>>>> What Gives? >>> >>> That would take a parenthetical expression. (I think that's the >>> term..) I doubt it's possible without a scientific calculator. >>> >>> BTW, any number, divided by 35% of itself would give you 2.857xxx >>> You should get that number by clicking 480000/35%= or 50/35%= >>> >>> hth, not trying to be a bore, nor a boor.. > > > 480000 / (35% [of 480000 which is 168000]) = 2.8xx > > That actually looks right to me.. It doesn't look right to me. The assumption in your example is that the 35% represents 35% of 480000, we don't know that to be true. The problem is that the OP presented us with a bit of an oddball mathematical problem, dividing by percents is not a standard way of doing things. In the real world when presented with that problem one would ask 35 percent of what? Without knowing the only correct answer is to convert 35% to its fractional or decimal value. 35% = 35/100 = .35 If we recall our grade school math about dividing fractions and reciprocals we get: 480000/35% = 480000/(35/100) = (480000/1)x(100/35) = 1371428.571 John
Guest Nightowl Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... NoConsequence <none@none.net> wrote on Wed, 26 Sep 2007: [Dragon said:] >>>> 480000 / 35% = >>>> >>>> And you get the result: 168000 >>>> >>>> When infact your result should be: 1371428.57xxxxx Dragon, you haven't finished the sum :-) Calc is showing what 35% of 480,000 is. When you see the 168,000, press "=" and you'll get 2.85xxx, as Joe said. >Are you trying to divide by .35? Or 35%? > >If the latter, then here's the problem: 35% of WHAT? If you aren't >clear, why would expect the calculator give you the answer you were >looking for? Methinks Dragon is puzzled because Calc's interpretation is different from his pocket calculator's and, apparently, Excel's. Calc takes 480,000 / 35% as meaning "divide 480,000 by 35% of itself" (I would, too). The pocket calculator thinks it means "divide 480,000 by 0.35". Mine does the same. -- Nightowl
Guest PowerUser Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... I'm an engineer so I know where your coming from. The Windows Calc is the irregular one- Even my scientific calculator can understand that you want to divide the two and express the answer as a percentage (multiplying the result of division my 100). I'd say don't use calc.exe.. unless it's stupidly simple. "Dragon" <noSpam_baadil@hotmail.com> wrote in message news:Og3qttIAIHA.320@TK2MSFTNGP04.phx.gbl... >I am missing some logic here, so please explain if it makes any sense to >you... > > Using Windows Calculator Press the following buttons: > > 480000 / 35% = > > And you get the result: 168000 > > When infact your result should be: 1371428.57xxxxx > > What Gives? >
Guest WaIIy Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... On Wed, 26 Sep 2007 15:19:58 -0700, "Dragon" <noSpam_baadil@hotmail.com> wrote: >I am missing some logic here, so please explain if it makes any sense to >you... > >Using Windows Calculator Press the following buttons: > >480000 / 35% = > >And you get the result: 168000 > >When infact your result should be: 1371428.57xxxxx > >What Gives? > http://www.microsoft.com/windowsxp/downloads/powertoys/xppowertoys.mspx Power Calc
Guest M.I.5¾ Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... "Dragon" <noSpam_baadil@hotmail.com> wrote in message news:OaXEcGJAIHA.4752@TK2MSFTNGP04.phx.gbl... > No. I am trying to devide 480000 by 35% (480000 / (35%) or 480000/35*100. > Just trying to find out if there is a bug in Win Calc. > Your error though is in not quite understanding the logic of Win Calc. Pressing the percentage key immediately after the 35 does not mean 35%. It gives you 48000% of 35 (which it correctly gives as 168000).
Guest M.I.5¾ Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... "Dragon" <noSpam_baadil@hotmail.com> wrote in message news:eIQnoFJAIHA.4984@TK2MSFTNGP06.phx.gbl... >I know I can break it down and it works. But I want to know is this a bug >in Win Calc? > To answer your question: No. Win Calc is doing exactly what you are telling it to do. Its just that what you are telling it to do is not what you think you are telling it to do.
Guest M.I.5¾ Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... "Nightowl" <owl@[127.0.0.1]> wrote in message news:zUCUgyUUJx+GFwl7@black.hole... > NoConsequence <none@none.net> wrote on Wed, 26 Sep 2007: > > [Dragon said:] > >>>>> 480000 / 35% = >>>>> >>>>> And you get the result: 168000 >>>>> >>>>> When infact your result should be: 1371428.57xxxxx > > Dragon, you haven't finished the sum :-) Calc is showing what 35% of > 480,000 is. When you see the 168,000, press "=" and you'll get 2.85xxx, as > Joe said. > >>Are you trying to divide by .35? Or 35%? >> >>If the latter, then here's the problem: 35% of WHAT? If you aren't >>clear, why would expect the calculator give you the answer you were >>looking for? > > Methinks Dragon is puzzled because Calc's interpretation is different from > his pocket calculator's and, apparently, Excel's. Calc takes > > 480,000 / 35% > > as meaning "divide 480,000 by 35% of itself" (I would, too). The pocket > calculator thinks it means "divide 480,000 by 0.35". Mine does the same. > No Calc interprets it as 'find 480000% of 35'. And it does so correctly. The problem is that not all calculators handle a percent key the same way.
Guest Ken Blake, MVP Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... On Wed, 26 Sep 2007 16:56:05 -0700, "Dragon" <noSpam_baadil@hotmail.com> wrote: > I get what you are saying. It makes sense. Having said that, which one is > wrong (Excel and $1 calculator or Win Calc)? As far as I'm concerned,all of the above (Excel and $1 calculator or Win Calc) are wrong. Sinner is correct. 480000 / (35%) is undefined. It's a meaningless calculation, It's like asking how much is 48 cows divided by 35 accordions. There is no answer. > "Sinner" <sinner@gatesofhell.org> wrote in message > news:KaCKi.104564$jH3.61007@bignews6.bellsouth.net... > > > > "Dragon" <noSpam_baadil@hotmail.com> wrote in message > > news:OaXEcGJAIHA.4752@TK2MSFTNGP04.phx.gbl... > >> No. I am trying to devide 480000 by 35% (480000 / (35%) or 480000/35*100. > >> Just trying to find out if there is a bug in Win Calc. > >> > >> > > > > > > The problem is the logic. 36% is a ratio, 35/100*X. It isn't a real > > number. > > > > 480000 can be divided by X, or 35%X, but not by 35%. > > > -- Ken Blake, Microsoft MVP Windows - Shell/User Please Reply to the Newsgroup
Guest Stephen Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... "Ken Blake, MVP" <kblake@this.is.am.invalid.domain> wrote in message news:kfknf3h9oi267e793dm5cmjv7fouvpb31r@4ax.com... > On Wed, 26 Sep 2007 16:56:05 -0700, "Dragon" > <noSpam_baadil@hotmail.com> wrote: > >> I get what you are saying. It makes sense. Having said that, which one is >> wrong (Excel and $1 calculator or Win Calc)? > > > As far as I'm concerned,all of the above (Excel and $1 calculator or > Win Calc) are wrong. Sinner is correct. 480000 / (35%) is undefined. > It's a meaningless calculation, It's like asking how much is 48 cows > divided by 35 accordions. There is no answer. > > Why is 480000 / (35%) undefined? A percentage is just that: "per cent", or "for each hundred". Hence 35% = 35/100 = 0.35 So, 480000 / (35%) is the same as 480000/0.35 Stephen
Guest Dragon Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... I agree. "PowerUser" <a@bbc.com> wrote in message news:OTPa%23$KAIHA.4592@TK2MSFTNGP03.phx.gbl... > I'm an engineer so I know where your coming from. The Windows Calc is the > irregular one- Even my scientific calculator can understand that you want > to divide the two and express the answer as a percentage (multiplying the > result of division my 100). > > I'd say don't use calc.exe.. unless it's stupidly simple. > > "Dragon" <noSpam_baadil@hotmail.com> wrote in message > news:Og3qttIAIHA.320@TK2MSFTNGP04.phx.gbl... >>I am missing some logic here, so please explain if it makes any sense to >>you... >> >> Using Windows Calculator Press the following buttons: >> >> 480000 / 35% = >> >> And you get the result: 168000 >> >> When infact your result should be: 1371428.57xxxxx >> >> What Gives? >> > >
Guest Dragon Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... that is exactly what I was thinking. "Stephen" <none> wrote in message news:%23XZsaGSAIHA.1184@TK2MSFTNGP04.phx.gbl... > "Ken Blake, MVP" <kblake@this.is.am.invalid.domain> wrote in message > news:kfknf3h9oi267e793dm5cmjv7fouvpb31r@4ax.com... >> On Wed, 26 Sep 2007 16:56:05 -0700, "Dragon" >> <noSpam_baadil@hotmail.com> wrote: >> >>> I get what you are saying. It makes sense. Having said that, which one >>> is >>> wrong (Excel and $1 calculator or Win Calc)? >> >> >> As far as I'm concerned,all of the above (Excel and $1 calculator or >> Win Calc) are wrong. Sinner is correct. 480000 / (35%) is undefined. >> It's a meaningless calculation, It's like asking how much is 48 cows >> divided by 35 accordions. There is no answer. >> >> > > Why is 480000 / (35%) undefined? > A percentage is just that: "per cent", or "for each hundred". > Hence 35% = 35/100 = 0.35 > So, 480000 / (35%) is the same as 480000/0.35 > > Stephen >
Guest John John Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... Ken Blake, MVP wrote: > On Wed, 26 Sep 2007 16:56:05 -0700, "Dragon" > <noSpam_baadil@hotmail.com> wrote: > > >>I get what you are saying. It makes sense. Having said that, which one is >>wrong (Excel and $1 calculator or Win Calc)? > > > > As far as I'm concerned,all of the above (Excel and $1 calculator or > Win Calc) are wrong. Sinner is correct. 480000 / (35%) is undefined. > It's a meaningless calculation, It's like asking how much is 48 cows > divided by 35 accordions. There is no answer. Interesting. Now put this to equation: Q- 480,000 is 35% of which number? In my way of seeing things the simple answer is to divide 480,000 by 35%. In math % does not represent cows or accordions, it is just a symbol that represents a ratio in hundredths, 35% = 35 one hundredths = 35/100, it is a way of expressing a fraction. Lotus 123 knows that % represents hundredths and does the math correctly, as does Excel and the $1 calculator. John
Guest Unknown Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... If you key that into the calculator it gives you the correct answer I.E. 480000/.35 "Dragon" <noSpam_baadil@hotmail.com> wrote in message news:en0iQoSAIHA.748@TK2MSFTNGP04.phx.gbl... > that is exactly what I was thinking. > > > "Stephen" <none> wrote in message > news:%23XZsaGSAIHA.1184@TK2MSFTNGP04.phx.gbl... >> "Ken Blake, MVP" <kblake@this.is.am.invalid.domain> wrote in message >> news:kfknf3h9oi267e793dm5cmjv7fouvpb31r@4ax.com... >>> On Wed, 26 Sep 2007 16:56:05 -0700, "Dragon" >>> <noSpam_baadil@hotmail.com> wrote: >>> >>>> I get what you are saying. It makes sense. Having said that, which one >>>> is >>>> wrong (Excel and $1 calculator or Win Calc)? >>> >>> >>> As far as I'm concerned,all of the above (Excel and $1 calculator or >>> Win Calc) are wrong. Sinner is correct. 480000 / (35%) is undefined. >>> It's a meaningless calculation, It's like asking how much is 48 cows >>> divided by 35 accordions. There is no answer. >>> >>> >> >> Why is 480000 / (35%) undefined? >> A percentage is just that: "per cent", or "for each hundred". >> Hence 35% = 35/100 = 0.35 >> So, 480000 / (35%) is the same as 480000/0.35 >> >> Stephen >> > >
Guest Dragon Posted September 27, 2007 Posted September 27, 2007 Re: Don't know how to use a calculator... I have to say I agree with you. This seems primary/middle scool math. I think there is a bug in Win Cal and this is why it is not calculating as it should. In 35% of nnn case, if nnnn is not defined, then it is 35 out of 100. "John John" <audetweld@nbnet.nb.ca> wrote in message news:%23S4iavSAIHA.4836@TK2MSFTNGP06.phx.gbl... > Ken Blake, MVP wrote: > >> On Wed, 26 Sep 2007 16:56:05 -0700, "Dragon" >> <noSpam_baadil@hotmail.com> wrote: >> >> >>>I get what you are saying. It makes sense. Having said that, which one is >>>wrong (Excel and $1 calculator or Win Calc)? >> >> >> >> As far as I'm concerned,all of the above (Excel and $1 calculator or >> Win Calc) are wrong. Sinner is correct. 480000 / (35%) is undefined. >> It's a meaningless calculation, It's like asking how much is 48 cows >> divided by 35 accordions. There is no answer. > > Interesting. Now put this to equation: > > Q- 480,000 is 35% of which number? > > In my way of seeing things the simple answer is to divide 480,000 by 35%. > In math % does not represent cows or accordions, it is just a symbol that > represents a ratio in hundredths, 35% = 35 one hundredths = 35/100, it is > a way of expressing a fraction. Lotus 123 knows that % represents > hundredths and does the math correctly, as does Excel and the $1 > calculator. > > John >
Recommended Posts