Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Roundup or rounddown
HI, I need a way to roundup if = .50 and rounddown <.49
1.86 = 2 1.5 = 2 1.49 = 1 7.25 = 7 Thanks -- Heather |
#2
|
|||
|
|||
Roundup or rounddown
Try this:
=ROUND(A1,0) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Heather" wrote in message ... HI, I need a way to roundup if = .50 and rounddown <.49 1.86 = 2 1.5 = 2 1.49 = 1 7.25 = 7 Thanks -- Heather |
#3
|
|||
|
|||
Roundup or rounddown
Isn't that what =Round() does?
=round(a1,0) Heather wrote: HI, I need a way to roundup if = .50 and rounddown <.49 1.86 = 2 1.5 = 2 1.49 = 1 7.25 = 7 Thanks -- Heather -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
roundup within a formula | Excel Worksheet Functions | |||
ROUNDUP copy/paste and fill handle not working | Excel Worksheet Functions | |||
Roundup for multiple cells | Excel Discussion (Misc queries) | |||
roundup within a formula | Excel Worksheet Functions | |||
Roundup | Excel Worksheet Functions |