Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need a formula, that will round up amounts to the nearest $2. ie.
if A1 value is $102.50, the total in the next cell (B1) should be rounded up to $104.00. I know its easy, but I cant work it out. TIA Esra |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
HELP with Rounding | Excel Worksheet Functions | |||
Rounding or not rounding | Excel Worksheet Functions | |||
Rounding | Excel Worksheet Functions | |||
Rounding | Excel Discussion (Misc queries) |