I am trying to create a formula that will compare data to a set number and if it passes that test then multiplies that data by 20%. For example, if any cells c1 through c43 are greater than $300, than that cell is multiplied by 20%. the total of those cells are added together for my total in the destination cell. so if I have 3 cells that pass the test and and each cell's number is multiplied by 20% returning a value of 50 than my final cell value would be 150.. Confused????
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
need help calculating if formula
- Thread starter PBUTTS
- Start date
mikerickson
MrExcel MVP
- Joined
- Jan 15, 2007
- Messages
- 24,355
You might use this formula to compute the sum.
=SUM(A1:A10)-SUMIF(A1:A10,">300",A1:A10)*.8
or a helper column with the formula
=A1*IF(A1>300, .2, 1) could be created and then summed
=SUM(A1:A10)-SUMIF(A1:A10,">300",A1:A10)*.8
or a helper column with the formula
=A1*IF(A1>300, .2, 1) could be created and then summed
Upvote
0
Similar threads
