software

What formula do you use if you want your total to show zero if it is below a
given amount in a specifide colume and/or the overage if it is above a given
amount in a specifide colume

Assume that if the sum of A1:A10 is less than or equal to 55 you want zero

=MAX(SUM(A1:A10)-55,0)

you can do the same for average--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Stewquot; gt; wrote in message
...
gt; What formula do you use if you want your total to show zero if it is below
gt; a
gt; given amount in a specifide colume and/or the overage if it is above a
gt; given
gt; amount in a specifide colume
Question is not too clear but do these help?

=IF(SUM(A1:A200)lt;1000,0,SUM(A1:A200) to show 0 if SUM lt; 1000
=IF(SUM(A1:A200)gt;5000,0,SUM(A1:A200) to show 0 if SUM gt; 5000

OR to show 0 if either condition applies
=IF(OR(SUM(A1:A200)lt;1000, SUM(A1:A200)gt;5000,0,SUM(A1:A200))

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from emailquot;Stewquot; gt; wrote in message
...
gt; What formula do you use if you want your total to show zero if it is below
gt; a
gt; given amount in a specifide colume and/or the overage if it is above a
gt; given
gt; amount in a specifide colume
If I understand what you want:

For example,
Sum A1:A10, and if total is:
Less then 0, display 0,
More then 25, display 25,

=MAX(0,MIN(25,SUM(A1:A10)))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;Stewquot; gt; wrote in message
...
gt; What formula do you use if you want your total to show zero if it is below
a
gt; given amount in a specifide colume and/or the overage if it is above a
given
gt; amount in a specifide colume