Problem with formula using an answer of another cell formula

IN CELL A11, I HAVE 39,500

IN CELL B11, I HAVE =A11*0.63
WHICH GIVES ME 24,885 IN CELL B11
CORRECT

IN CELL C6, I HAVE $1.34
CORRECT

IN CELL C9, I HAVE =1/C6
WHICH GIVES ME .75 IN CELL C9
CORRECT

IN CELL C11, I HAVE =B11/C9
MY ANSWER IN C11 SHOULD BE 33,180...BUT IT ISN'T...SOMETHING TO DO
WITH THE
ANSWER TO C9 (.75) NOT THE FORMULA OF C9 (=1/C6)



I WANT TO BE ABLE TO PERIODICALLY CHANGE CELL C6 AND HAVE IT CHANGE
C11 AND SO ON WITH ONLY 1 CHANGE TO C6...



PLEASE HELP!!!!!!!!!!!!

Hi
first: please turn off your Caps-Lock. Makes it difficult to read

Second: As you haven't stated your exact problem I assume you get a
rounding 'error'. If this is true, this isn't exactly an error (see:
http://www.cpearson.com/excel/rounding.htm)
To prevent this use the ROUND function. e.g. enter the following in C11
=ROUND(B11/C9,3)



--
Regards
Frank Kabel
Frankfurt, Germany


KIMBERLY wrote:
IN CELL A11, I HAVE 39,500

IN CELL B11, I HAVE =A11*0.63
WHICH GIVES ME 24,885 IN CELL B11
CORRECT

IN CELL C6, I HAVE $1.34
CORRECT

IN CELL C9, I HAVE =1/C6
WHICH GIVES ME .75 IN CELL C9
CORRECT

IN CELL C11, I HAVE =B11/C9
MY ANSWER IN C11 SHOULD BE 33,180...BUT IT ISN'T...SOMETHING TO DO
WITH THE
ANSWER TO C9 (.75) NOT THE FORMULA OF C9 (=1/C6)



I WANT TO BE ABLE TO PERIODICALLY CHANGE CELL C6 AND HAVE IT CHANGE
C11 AND SO ON WITH ONLY 1 CHANGE TO C6...



PLEASE HELP!!!!!!!!!!!!

Kimberly,

It's a simply problem of rounding. By dividing 1 by the
number 1.34 in cell C9 Excel returns 0.746269 (which is
not exactly 0.75).

I would suggest using more decimal places in cell C6, or
rounding the answer in C9 to nearest 100th. (see the
=ROUND function in Excel help).

I hope that helps.

Eric

"Eric" wrote in message ...
Kimberly,

It's a simply problem of rounding. By dividing 1 by the
number 1.34 in cell C9 Excel returns 0.746269 (which is
not exactly 0.75).

I would suggest using more decimal places in cell C6, or
rounding the answer in C9 to nearest 100th. (see the
=ROUND function in Excel help).

I hope that helps.

Eric



Thank you for your help...and sorry for the CAPS.

Your suggestion about ROUNDING is not working... the problem is that
if in cell C11, I use the formula =B11/.75...I get the correct answer
....33,180.

But when I try to used the formula in C9 of =1/C6, the answer is not
the same even though the answer the =1/C6 is .75 (or .74....)

Why won't the formula =B11/C9 give me the correct answer...instead it
gives me an answer of $33,345.90.

I would really appreciate it if you could help again...

Thank you in advance, Kim

"Frank Kabel" wrote in message ...
Hi
first: please turn off your Caps-Lock. Makes it difficult to read

Second: As you haven't stated your exact problem I assume you get a
rounding 'error'. If this is true, this isn't exactly an error (see:
http://www.cpearson.com/excel/rounding.htm)
To prevent this use the ROUND function. e.g. enter the following in C11
=ROUND(B11/C9,3)



--
Regards
Frank Kabel
Frankfurt, Germany


KIMBERLY wrote:
IN CELL A11, I HAVE 39,500

IN CELL B11, I HAVE =A11*0.63
WHICH GIVES ME 24,885 IN CELL B11
CORRECT

IN CELL C6, I HAVE $1.34
CORRECT

IN CELL C9, I HAVE =1/C6
WHICH GIVES ME .75 IN CELL C9
CORRECT

IN CELL C11, I HAVE =B11/C9
MY ANSWER IN C11 SHOULD BE 33,180...BUT IT ISN'T...SOMETHING TO DO
WITH THE
ANSWER TO C9 (.75) NOT THE FORMULA OF C9 (=1/C6)



I WANT TO BE ABLE TO PERIODICALLY CHANGE CELL C6 AND HAVE IT CHANGE
C11 AND SO ON WITH ONLY 1 CHANGE TO C6...



PLEASE HELP!!!!!!!!!!!!


Thank you for your help...and sorry for the CAPS.

Your suggestion about ROUNDING is not working... the problem is that
if in cell C11, I use the formula =B11/.75...I get the correct answer
....33,180.

But when I try to used the formula in C9 of =1/C6, the answer is not
the same even though the answer the =1/C6 is .75 (or .74....)

Why won't the formula =B11/C9 give me the correct answer...instead it
gives me an answer of $33,345.90.

I would really appreciate it if you could help again...

Thank you in advance, Kim