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!!!!!!!!!!!!
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!!!!!!!!!!!!