Display Formula Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Hi
not really sure what your problem is :-)
Can you provide examples for B1 and C1 and describe your expected
result
 
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.
 
<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.
 
Back
Top