Excel Formulas

Tom · Dec 1, 2007

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 · Dec 1, 2007

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

Help Creating Excel Formula	4	Apr 10, 2010
formula in excel	2	Dec 7, 2009
Error with sum formula in excel 2007	4	Oct 9, 2008
Set non-continuous PrintArea via Function / Name	0	Apr 11, 2019
Need a formula to determine if date falls within a date range then	2	Sep 19, 2008
Spreadsheet question	5	Oct 22, 2009
Creating a formula relating to several cells	2	Oct 18, 2010
Extract Formula to Text	6	Apr 8, 2009

Ask a Question