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

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

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

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