**Trying to use answer from another formula cell in another formula

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

KIMBERLY

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




This was my original question:

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!!!!!!!!!!!!
 
You need to use Round in C9 to have =ROUND(1/C6,2) to come up with your answer

The reason this is not working without the round is that you are not dividing by
..75 but by .746269...




: 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
:
:
:
:
: This was my original question:
:
: 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!!!!!!!!!!!!
 
Back
Top