Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formulas
im trying to use a formula for % of a sum that is greater than 2000
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |