formulas

[dave8888]

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

[Aussie CPA]

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

[dave8888]

thanks for your help i finally figured it out as:
=IF(D66>=2000,D66*0.001,0)


"Aussie CPA" wrote:

> 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