Thanks to all of you.

Ted



"Paul B" wrote in message
...
Ted, maybe something like this,

=IF(SUM(A1:A10)56,56,SUM(A1:A10))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Ted Dawson" wrote in message
...
I have an autosum cell, but I don't want the displayed value to be any
higher than 56, help?


Ted