One way,
something like this in say, B1: =MIN(SUM(A1:A10),56)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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