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


--
BrandenKilgore
------------------------------------------------------------------------
BrandenKilgore's Profile: http://www.excelforum.com/member.php...o&userid=26145
View this thread: http://www.excelforum.com/showthread...hreadid=394730

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


--
David Billigmeier


"BrandenKilgore" wrote:


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


--
BrandenKilgore
------------------------------------------------------------------------
BrandenKilgore's Profile: http://www.excelforum.com/member.php...o&userid=26145
View this thread: http://www.excelforum.com/showthread...hreadid=394730

BrandenKilgore,

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

HTH,
Bernie
MS Excel MVP


"BrandenKilgore" <BrandenKilgore.1tke6z_1123704354.3178@excelforu m-nospam.com wrote in message
news:BrandenKilgore.1tke6z_1123704354.3178@excelfo rum-nospam.com...

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


--
BrandenKilgore
------------------------------------------------------------------------
BrandenKilgore's Profile: http://www.excelforum.com/member.php...o&userid=26145
View this thread: http://www.excelforum.com/showthread...hreadid=394730