Posts: 1

Hi all,

Hoping for some help with a spreadsheet. What I would like to do is format a range of cells such that the number is displayed as one of this group {6 8 10 12 14 16 18 20 22 25 28 30 32 36 40 45 50 55 60 70 80}

I would like the cell number to be rounded up to the next whole number above it from the list above. eg. cell number is 11.6 I want it to display 12, number 60.0001, I want it to display 70 and if 60 exactly display 60.

I am not sure wheter or not excel could do this and how difficult it will be. Hopefully somebody has some idea of wheter or not this is possible with excel and is so how to go about it. Wink

I have looked at conditional formating but I don't know/think this is the solution...


Thanks in advance


James