As I read the problem, if the value in W58 is between 0 and 23, it should
return a 0. If it's between 24 and 29, it should return a 24. If it's
between 30 and 35, it should return a 30. Etc....

Would the CEILING function do that?

"Ken Wright" wrote:

If your min and max are covered by input restrictions then how about

=CEILING(W58,6)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"John F" wrote in message
...
Using Excel 2003

Using the following formula
It works great Except that when the input cell is blank ( or "deleted"),
a
Zero
is entered in cell "W?"
This in turn causes the formula to return a 30, NOT the Zero that I'm
Looking for.
Can the formula be reworked? or somehow multiple nested?
(the input/supply cell is restricted to minimum of 24 and maximum of 72,
so that part is looked after)


=IF(W58=24,24,IF(W58<=30,30,IF(W58<=36,36,IF(W58<= 42,42,IF(W58<=48,48,IF(W58
<=54,54,IF(W58<=60,60,IF(W58<=66,66,72))))))))

Thanks
--
John F. Scholten