Less than equal to FORMULA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone. I need help writing a formula that takes into account the following information
I need the sum of a line. If that line is less than or equal to 7000, then keep that number as a total. If it is larger than 7000, then keep 7000 as a total

How can I accomplish this

Thanks
 
this?
=MIN(SUM(I1:I21),7000)

--
Don Guillett
SalesAid Software
(e-mail address removed)
Gerardo said:
Hi everyone. I need help writing a formula that takes into account the following information:
I need the sum of a line. If that line is less than or equal to 7000,
Click to expand...
then keep that number as a total. If it is larger than 7000, then keep 7000
as a total.
 
=MAX(7000,SUM(whatever))

--

Vasant

Gerardo said:
Hi everyone. I need help writing a formula that takes into account the following information:
I need the sum of a line. If that line is less than or equal to 7000,
Click to expand...
then keep that number as a total. If it is larger than 7000, then keep 7000
as a total.
 
Try this:

=MIN(7000,SUM(A1:X1))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi everyone. I need help writing a formula that takes into account the
following information:
I need the sum of a line. If that line is less than or equal to 7000, then
keep that number as a total. If it is larger than 7000, then keep 7000 as a
total.

How can I accomplish this?

Thanks
 
Sorry; I meant MIN rather than MAX.



Vasant Nanavati said:
=MAX(7000,SUM(whatever))

--

Vasant


then keep that number as a total. If it is larger than 7000, then keep 7000
as a total.
Click to expand...
 
Back
Top