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


--
bailej03
------------------------------------------------------------------------
bailej03's Profile: http://www.excelforum.com/member.php...o&userid=23764
View this thread: http://www.excelforum.com/showthread...hreadid=374142