Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas with percentages
maybe someone can help me with this..if someone increases an amount by %25 then they get a point, if they increase it by %50 they get 2 points, by %75, 3 points, and %100, 4 points.... can you figure that one out for me please? how would i a formula that would read this? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200508/1 |
#2
|
|||
|
|||
Hi,
Lets say the original amount is in A2 and the increased amount is in A3 , then use =ROUND((((A3-A2)*100)/A2)/25,0) Regards Govind. Trisha V via OfficeKB.com wrote: maybe someone can help me with this..if someone increases an amount by %25 then they get a point, if they increase it by %50 they get 2 points, by %75, 3 points, and %100, 4 points.... can you figure that one out for me please? how would i a formula that would read this? |
#3
|
|||
|
|||
ok and if I already have a column that calculates for example A3 and A2? Govind wrote: Hi, Lets say the original amount is in A2 and the increased amount is in A3 , then use =ROUND((((A3-A2)*100)/A2)/25,0) Regards Govind. maybe someone can help me with this..if someone increases an amount by %25 then they get a point, if they increase it by %50 they get 2 points, by %75, 3 points, and %100, 4 points.... can you figure that one out for me please? how would i a formula that would read this? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200508/1 |
#4
|
|||
|
|||
Hi,
If you already have a column that calculates the variance in % between A3 and A2 then just use =ROUND(A4/25,0) where A4 is the cell with the increase % between A2 and A3. This formula rounds off to the nearest point. If the increase is say 70%, it would give 3 points (rounded off to 75%). If you dont want any rounding off ,you can just do simply =A4/25. Govind. If you want only Trisha V via OfficeKB.com wrote: ok and if I already have a column that calculates for example A3 and A2? Govind wrote: Hi, Lets say the original amount is in A2 and the increased amount is in A3 , then use =ROUND((((A3-A2)*100)/A2)/25,0) Regards Govind. maybe someone can help me with this..if someone increases an amount by %25 then they get a point, if they increase it by %50 they get 2 points, by %75, 3 points, and %100, 4 points.... can you figure that one out for me please? how would i a formula that would read this? |
#5
|
|||
|
|||
ok that somewhat worked...if I needed the negative numbers to be 0? and also They cant go over 100%? I think Im confusing both of us...lol Govind wrote: Hi, If you already have a column that calculates the variance in % between A3 and A2 then just use =ROUND(A4/25,0) where A4 is the cell with the increase % between A2 and A3. This formula rounds off to the nearest point. If the increase is say 70%, it would give 3 points (rounded off to 75%). If you dont want any rounding off ,you can just do simply =A4/25. Govind. If you want only ok and if I already have a column that calculates for example A3 and A2? [quoted text clipped - 14 lines] how would i a formula that would read this? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200508/1 |
#6
|
|||
|
|||
Hi,
Use =IF(A4<0,0,MIN(4,ROUND(A4/25,0))) where A4 is the % increase between A2 and A3. If you dont want any rounding off of points, use =IF(A4<0,0,MIN(4,A4/25)) Regards Govind. Trisha V via OfficeKB.com wrote: ok that somewhat worked...if I needed the negative numbers to be 0? and also They cant go over 100%? I think Im confusing both of us...lol Govind wrote: Hi, If you already have a column that calculates the variance in % between A3 and A2 then just use =ROUND(A4/25,0) where A4 is the cell with the increase % between A2 and A3. This formula rounds off to the nearest point. If the increase is say 70%, it would give 3 points (rounded off to 75%). If you dont want any rounding off ,you can just do simply =A4/25. Govind. If you want only ok and if I already have a column that calculates for example A3 and A2? [quoted text clipped - 14 lines] how would i a formula that would read this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |