Payroll calculating

[Clay]

With a rang of cells equaling 90,(a1,b1,c1 and so), how do you get the
calculating to stop at 40. Useing Excel 2000

[Peo Sjoblom]

=MIN(40,SUM(A1:C1))


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com



"Clay" <Clay@discussions.microsoft.com> wrote in message
news:645B90F4-CB44-4D70-9AFE-BDBAB63C9BC2@microsoft.com...
> With a rang of cells equaling 90,(a1,b1,c1 and so), how do you get the
> calculating to stop at 40. Useing Excel 2000