ExcelBanter - formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formulas (https://www.excelbanter.com/excel-discussion-misc-queries/52062-formulas.html)

dave8888

formulas

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

Aussie CPA

formulas

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

formulas

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

All times are GMT +1. The time now is 07:11 AM.