small change for negatives Kostis

=CEILING(MAX(A12,0),5)/2


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"vezerid" wrote in message
ups.com...
Sherry,
in your example, the value returned by each IF is half the upper limit.
Since the upper limit of each interval increases by 5, and if this
pattern continues, then you can replace your formula with:

=CEILING(A12,5)/2

HTH
Kostis Vezerides