Display Formula Values

[Guest]

I have a number of formulas that are displaying the result using the value
that is displayed in a referenced cell rather than what was actually input.
For example, if my formula in cell A1 is B1*C1 and my value in C1 is .075 and
the cell is formatted to display a percentage with no decimal places my
formula in B1 uses 8% instead of 7.5%. How can I address this across the
entire workbook rather than having to change the format in each of the
necessary cells. Thanks for your help.

 

[RagDyeR]

What formula do you have in B1?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

I have a number of formulas that are displaying the result using the value
that is displayed in a referenced cell rather than what was actually input.
For example, if my formula in cell A1 is B1*C1 and my value in C1 is .075
and
the cell is formatted to display a percentage with no decimal places my
formula in B1 uses 8% instead of 7.5%. How can I address this across the
entire workbook rather than having to change the format in each of the
necessary cells. Thanks for your help.

 

[Frank Kabel]

Hi
not really sure what your problem is
Can you provide examples for B1 and C1 and describe your expected
result

 

[Guest]

My apologies. I meant to say that "the formula in A1 (not B1) uses 8% instead
of 7.5%". In another words it's using the value displayed in the cell (which
has been rounded up to accommodate the format) not the value I actually
input. Thanks again.

 

[RagDyeR]

<Tools> <Options> <Calculation> tab,
And *uncheck* "Precision As Displayed".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

My apologies. I meant to say that "the formula in A1 (not B1) uses 8%
instead
of 7.5%". In another words it's using the value displayed in the cell
(which
has been rounded up to accommodate the format) not the value I actually
input. Thanks again.

 

[Frank Kabel]

Hi
as formulas can't change formats you have to format the target cell
manually