How do i Use actual number displayed?

B

BrandenKilgore

I'm working on a spreadsheet with a lot of referenced formulas. I have
it set to where, for example, .08*19 displays the answer "2" because I
have it with no decimal places. But when I go to reference this
cell in another formula, I can't get it to use "2", it uses the actual
value which is 1.52, even though 2 is shown. I need it to
use the value shown in the calculation. Any idea of how I can get this
to use the displayed value?
Thanks
 
D

David Billigmeier

Either include a ROUND() function in the cell where .08*19 is located, or in
the formula that references this cell. For example, if the .08*19 value is
stored in A1, you would write:

=ROUND(A1,0)

instead of just calling A1
 
B

Bernie Deitrick

BrandenKilgore,

Use Tools / Options.... Calculation tab, check "Precision as displayed"

HTH,
Bernie
MS Excel MVP
 
Top