im trying to use a formula for % of a sum that is greater than 2000
A Aussie CPA Oct 25, 2005 #2 try =((sum(XX:XX)-20000)/Sum(xx:xx))*100 I think I read this correctly. Adam Wood
D dave8888 Oct 25, 2005 #3 thanks for your help i finally figured it out as: =IF(D66>=2000,D66*0.001,0)
