software

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
savefile.com/projects/236895
xdemechanik
---
quot;Ted Dawsonquot; gt; wrote in message
...
gt; I have an autosum cell, but I don't want the displayed value to be any
gt; higher than 56, help?
gt;
gt;
gt; Ted
gt;
gt;

=IF(SUM(B4:B13)lt;=56,SUM(B4:B13),quot;quot;)
this is what I came up with--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=519184Ted, maybe something like this,

=IF(SUM(A1:A10)gt;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 amp; 2003

quot;Ted Dawsonquot; gt; wrote in message
...
gt; I have an autosum cell, but I don't want the displayed value to be any
gt; higher than 56, help?
gt;
gt;
gt; Ted
gt;
gt;
Thanks to all of you.

Ted
quot;Paul Bquot; gt; wrote in message
...
gt; Ted, maybe something like this,
gt;
gt; =IF(SUM(A1:A10)gt;56,56,SUM(A1:A10))
gt;
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;Ted Dawsonquot; gt; wrote in message
gt; ...
gt;gt; I have an autosum cell, but I don't want the displayed value to be any
gt;gt; higher than 56, help?
gt;gt;
gt;gt;
gt;gt; Ted
gt;gt;
gt;gt;
gt;
gt;