Max Value

[Ted Dawson]

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


Ted

[davesexcel]

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

[Max]

One way,
something like this in say, B1: =MIN(SUM(A1:A10),56)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ted Dawson" <[email protected]> wrote in message
news:[email protected]...
> I have an autosum cell, but I don't want the displayed value to be any
> higher than 56, help?
>
>
> Ted
>
>

[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

"Ted Dawson" <[email protected]> wrote in message
news:[email protected]...
> I have an autosum cell, but I don't want the displayed value to be any
> higher than 56, help?
>
>
> Ted
>
>

[Ted Dawson]

Thanks to all of you.

Ted



"Paul B" <[email protected]> wrote in message
news:ua%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> I have an autosum cell, but I don't want the displayed value to be any
>> higher than 56, help?
>>
>>
>> Ted
>>
>>
>
>