Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Decimal question in variable?
Hi,
I would like to know if it exists a function to round up or down a three or more decimal at only two, I am not talking about the content of a cell but at the content of a variable Ex: B = 13.34567 A = 13.35 C = A - B I would like In this Example the result of C to be 0. In fact I would like round up B to be 13.35. or 13.34 if B was 13.34458 Thank you very much Jean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round variable to 4 decimal places | Excel Programming | |||
Capturing Decimal Values in Variable - Losing decimals when summin | Excel Programming | |||
Entering numbers with variable decimal places. | Excel Worksheet Functions | |||
format variable to 3 decimal | Excel Programming | |||
variable as Currency two decimal places | Excel Programming |