View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Debra Dalgleish
 
Posts: n/a
Default use displayed value in calculation

What values are in cells A1 and B1?
A small number, showing two decimal places, could display as 0.00

michael wrote:
quick question -

if I perform a simple calculation of =(a1+b1) in the m1 cell, and then
need to use that result in another calculation in the n1 cell
=(m1*3.14), why do I get a value of 0.00 returned?



michae



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html