| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding Up or down to 1/2 Units
Many thanks, worked perfectly,
Dale Wid "Peo Sjoblom" wrote: Try =IF($B$100,ROUND(B10/15/0.5,0)*0.5,"") -- Regards, Peo Sjoblom Portland, Oregon "DaleWid" wrote in message ... I'm trying to round up or down after executing a formula in a cell. Here's formula I have in cell =IF($B$100,+B10/15,"") Assuming result is a positive number, I want to round to the nearest .5, up or down. Thanks for any advice you might have. DaleWid "Peo Sjoblom" wrote: With your value in A1 =ROUND(A1/0.5,0)*0.5 -- Regards, Peo Sjoblom "Mal" wrote in message ... Hi People, Is there a way to round up or down in 1/2 units. e.g. 2.3 up to 2.5, 2.1 down to 2. Any help appreciated. Thanks, Mal |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage rounding error in charts | Excel Discussion (Misc queries) | |||
| Changing Secondary axis value units | Charts and Charting in Excel | |||
| Page margin units | Excel Worksheet Functions | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
| Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel | |||
Threaded Mode
