Help with formula

[Guest]

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

 

[Peo Sjoblom]

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

http://nwexcelsolutions.com

 

[Bernard Liengme]

Question is not too clear but do these help?

=IF(SUM(A1:A200)<1000,0,SUM(A1:A200) to show 0 if SUM < 1000
=IF(SUM(A1:A200)>5000,0,SUM(A1:A200) to show 0 if SUM > 5000

OR to show 0 if either condition applies
=IF(OR(SUM(A1:A200)<1000, SUM(A1:A200)>5000,0,SUM(A1:A200))

 

[Ragdyer]

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)))