Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculator Answer Doesn't Match Excel Answer
This may be a stupid question, but I divided $3,180,000 by 3% on a
calculator, and got $106,000,000. When I did the same computation in Excel with this formula: =3,180,000/3% I get the same answer. However, when I use a formula that references the cells containing these same numbers: =B43/B44 (where B43 contains the number $3,180,000 and B44 contains the number 3% Excel gives me $103,246,753.25 as the answer. Why is that? B43 is formatted as currency with two decimal places, and B44 is formatted as a percentage with zero decimals. The cell containing the formula (=B43/B44) is formatted as currency with two decimals. This calculation is part of a worksheet that will be turned in as part of a college-level Finance class exam. The exam is due tonight at midnight. HELP! Thanks, GwenH |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculator Answer Doesn't Match Excel Answer
The value in B44 is probably 3.08% but is being displayed as 3% by reason of
format. -- Gary''s Student - gsnu200808 "GwenH" wrote: This may be a stupid question, but I divided $3,180,000 by 3% on a calculator, and got $106,000,000. When I did the same computation in Excel with this formula: =3,180,000/3% I get the same answer. However, when I use a formula that references the cells containing these same numbers: =B43/B44 (where B43 contains the number $3,180,000 and B44 contains the number 3% Excel gives me $103,246,753.25 as the answer. Why is that? B43 is formatted as currency with two decimal places, and B44 is formatted as a percentage with zero decimals. The cell containing the formula (=B43/B44) is formatted as currency with two decimals. This calculation is part of a worksheet that will be turned in as part of a college-level Finance class exam. The exam is due tonight at midnight. HELP! Thanks, GwenH |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculator Answer Doesn't Match Excel Answer
Thanks! Can you tell I've been looking at this monster too long?
GwenH "Gary''s Student" wrote: The value in B44 is probably 3.08% but is being displayed as 3% by reason of format. -- Gary''s Student - gsnu200808 "GwenH" wrote: This may be a stupid question, but I divided $3,180,000 by 3% on a calculator, and got $106,000,000. When I did the same computation in Excel with this formula: =3,180,000/3% I get the same answer. However, when I use a formula that references the cells containing these same numbers: =B43/B44 (where B43 contains the number $3,180,000 and B44 contains the number 3% Excel gives me $103,246,753.25 as the answer. Why is that? B43 is formatted as currency with two decimal places, and B44 is formatted as a percentage with zero decimals. The cell containing the formula (=B43/B44) is formatted as currency with two decimals. This calculation is part of a worksheet that will be turned in as part of a college-level Finance class exam. The exam is due tonight at midnight. HELP! Thanks, GwenH |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculator Answer Doesn't Match Excel Answer
Don't kill yourself over stuff like this. Once you have given the problem a
good faith effort, post the question. We are always here. -- Gary''s Student - gsnu200808 "GwenH" wrote: Thanks! Can you tell I've been looking at this monster too long? GwenH "Gary''s Student" wrote: The value in B44 is probably 3.08% but is being displayed as 3% by reason of format. -- Gary''s Student - gsnu200808 "GwenH" wrote: This may be a stupid question, but I divided $3,180,000 by 3% on a calculator, and got $106,000,000. When I did the same computation in Excel with this formula: =3,180,000/3% I get the same answer. However, when I use a formula that references the cells containing these same numbers: =B43/B44 (where B43 contains the number $3,180,000 and B44 contains the number 3% Excel gives me $103,246,753.25 as the answer. Why is that? B43 is formatted as currency with two decimal places, and B44 is formatted as a percentage with zero decimals. The cell containing the formula (=B43/B44) is formatted as currency with two decimals. This calculation is part of a worksheet that will be turned in as part of a college-level Finance class exam. The exam is due tonight at midnight. HELP! Thanks, GwenH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
to get the same answer from a normal calculator | Excel Worksheet Functions | |||
to get the same answer from a normal calculator | Excel Worksheet Functions | |||
Using MATCH function does not return correct answer | Excel Worksheet Functions | |||
match colC to ColA, put row from ColB for 'answer' | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |