Max Value
 

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


Ted

Max Value
 

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

Max Value
 

=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

Max Value
 

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

Max Value
 

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