=ROUND(C2,2)*A2
instead of =C2*A2

"Glen Davidson" <Glen wrote in message
...
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