Hi.

=MIN(SUM(B5:M5),24)

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"phooey" wrote in message
...
I am calculating sick day accrual.
It's cumulative and adds hours each month, to a max of 24 hours.

Here's what I have, and it works:
=IF(B5+C5+D5+E5+F5+G5+H5+I5+J5+K5+L5+M5=24,24,B5+ C5+D5+E5+F5+G5+H5+I5+J5+K5+L5+M5)

I would like to make this shorter.
I've tried using: =IF(B5:M5=24,24,B5:M5), but it errors.

Ideas??

I Know.. if it's not broke don't fix it.
But I know there has to be an easier/shorter way.....