Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I know this is a rookie question, but for some reason, I cannot seem to wrap my mind around it. I'm attempting to round a number to the nearest 5 or 0. Here's an example. If A1 = 40 (no rounding) If A1 = 41 or 42 (round to 40) If A1 = 43, 44, 46 or 47 (round to 45) If A1 = 45 (no rounding) If A1 = 48 or 49 (round to 50) Perhaps, I've been staring at this too long! Thanks in advance to anyone who provides the "swift kick" to the head! Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rounding numbers up or down | Excel Discussion (Misc queries) | |||
Rounding up to the nearest nickel | Excel Discussion (Misc queries) | |||
Rounding to nearest integer | Excel Worksheet Functions | |||
Rounding numbers to the nearest thousand | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |