Cell.Value to 2 decimal places

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.

Please Login or Register  to view this content.

Hello Jonn,

Here is the conversion code..

Please Login or Register  to view this content.

Sincerely,
Leith Ross

what does that formula do?

Thanks

Hello Jonn,

It strips away any decimals greater than 2. The number will only contain 2 decimal numbers after the decimal point. However, it does not round the second number off.

Sincerely,
Leith Ross