| 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 | |||
Hybrid Mode
