Payroll calculating Clay 05.08.2006 01:23:01 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

Re: Payroll calculating "Peo Sjoblom" <peo.sjoblom[ at ]nw^^excelsolutions.com> 05.08.2006 02:36:00 =MIN(40,SUM(A1:C1)) -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "Clay" <Clay[ at ]discussions.microsoft.com> wrote in message news:645B90F4-CB44-4D70-9AFE-BDBAB63C9BC2[ at ]microsoft.com... [Quoted Text] > 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