| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
