Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When I try to break a value into 3 equal parts
ActiveCell.Offset(-1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = "=R[1]C/3" ActiveCell.Offset(-1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = "=(R[2]C-R[1]C)/2" ActiveCell.Offset(-1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = "=R[3]C-(R[2]C+R[1]C)" it works fine, but how can I Round each new amount to 2 decimals for currency? I have some with 8 or 10 #'s after the decimal, not what I want. kind of like ActiveCell.FormulaR1C1 = Round("=R[1]C/3",2) but I know that won't work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Worksheet rounding vs VBA rounding | Excel Programming | |||
Code not rounding | Excel Programming | |||
Rounding questions: (Formula and Code) ? | Excel Programming |