T
Ted Dawson
I have an autosum cell, but I don't want the displayed value to be any
higher than 56, help?
Ted
higher than 56, help?
Ted
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
One way,
something like this in say, B1: =MIN(SUM(A1:A10),56)
something like this in say, B1: =MIN(SUM(A1:A10),56)
D
davesexcel
=IF(SUM(B4:B13)<=56,SUM(B4:B13),"")
this is what I came up with
this is what I came up with
P
Paul B
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
=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
T
Ted Dawson
Thanks to all of you.
Ted
Ted
Paul B said: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