Hi,

the code below takes the value of the cell which is often 3 to 5 decimal places and inputs the formula, however, how can i make VAR = only 2 decimal places insted of it absolute value
i.e.

A1 = 2.34678 So I want: -
VAR = 2.35
So the End result is
'=SUM(2.35)*(1-C10)'

NOT - '=SUM(2.34678)*(1-C10)'

as this confuses people because they keep say the calculations are wrong because it is formatted in 2 decimal places.

Cells(ROWPOS, 6).Select
    VAR = ActiveCell.Value 'assigns the current cell value to VAR
    Cells(ROWPOS, 6) = "= Sum(" & VAR & ")* (1-C10)"