View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Glen Davidson Glen Davidson is offline
external usenet poster
 
Posts: 1
Default Changing Decimal Places for Multiplication

I use 4 place numbers in my investment calulations but the last number to be
multiplyed by the the number of shares is a 2 place decimal but the
calculation still give me the 4 place multiplication.

Example:

shares price/share +.245 change to 2 dec
Value(shares*10.85)
1500 10.6000 10.8450 10.85 16267.5

I want 10.85 x 1500 which would be16275 not the 16267.5

Thanks

Glen