Problem with formula using an answer of another cell formula

  • Thread starter Thread starter KIMBERLY
  • Start date Start date
K

KIMBERLY

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)
 
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 said:
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
Click to expand...



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 said:
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)
Click to expand...


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
 
Back
Top