try =((sum(XX:XX)-20000)/Sum(xx:xx))*100
I think I read this correctly.

Adam Wood


"dave8888" wrote:

im trying to use a formula for % of a sum that is greater than 2000