I have an autosum cell, but I don't want the displayed value to be any
higher than 56, help?


Ted

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

=IF(SUM(B4:B13)<=56,SUM(B4:B13),"")
this is what I came up with


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519184

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

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