#### Thebatfink

##### Active Member

- Joined
- Apr 8, 2007

- Messages
- 406

I guess I have an odd rounding up query. I want to know if its possible to make excel round up a number to the nearest number from within a list of numbers.

For instance my list could be

10

12

15

17

19

22

25

30

35

42

The numbers arent odds or evens or multiples of anything so I'm guessing there won't be an inbuilt function to do this but is there anyway I could get to the answer in a more round about way with helper calculations??

I guess I could use the following -

Code:

`=IF(A1>42,"Error",IF(A1<10,10,IF(AND(A1>10,A1<12),12,IF(AND(A1>12,A1<15),15, ..........`

but it seems excessive and I would like to be able to add numbers to the list occasionally without having to redo all the formulae.

Anyone have any ideas?

Thanks!

Batfink