ExcelBanter - Excel Formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel Formulas (https://www.excelbanter.com/excel-worksheet-functions/168080-excel-formulas.html)

tom

Excel Formulas

I need to total A1:A3 in A4 with a not to exceed value such as if sum is
greater then X, then X. Thanks

Peo Sjoblom

Excel Formulas

=MIN(X,SUM(A1:A3))

--

Regards,

Peo Sjoblom

"Tom" wrote in message
...
I need to total A1:A3 in A4 with a not to exceed value such as if sum is
greater then X, then X. Thanks

All times are GMT +1. The time now is 06:00 PM.