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" <[email protected]> wrote in message
news:[email protected]...
> 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