Conditional Percentage Increase

[nafri]

hi all

good day all

i have data in the follwing format..

HTML Code:

price
110
23
122
122
190
1111
3000
980
230
422
5000

i need to increase the value by a percentage.. so if it falls with in 1-130 increase by by 4.7% , 130 -400 increase 4.0%, 400 -600 increase by 3.8%, and so on.

i know how do i do it by paste special (learnt it from here) but i have to select the range manually and apply the change..Can i automate this using a macro .. i can sort the data in-order if needs be..but desperatly looking to automate.. i am no good at coding

thanks...

[Dave Hawley]

---

Try this formula. Array formulas will have curly brackets {} emcompassing the ENTIRE formula. You do not add these, you Enter the formula with Ctrl+Shift+Enter and Excel will add them (details: Array formulas). Many more Excel Formulas

	=A1*SUM(1,CHOOSE(MATCH(A1,{10000,600,400,130},-1),0.25,0.37,0.4,0.47))

---

Copy down and Paste special as values over the top of the orginals. Follow the descending pattern in the MATCH function and the acsending pattern for CHOOSE

[nafri]

---

Try this formula. Array formulas will have curly brackets {} emcompassing the ENTIRE formula. You do not add these, you Enter the formula with Ctrl+Shift+Enter and Excel will add them (details: Array formulas). Many more Excel Formulas

	=A1*SUM(1,CHOOSE(MATCH(A1,{10000,600,400,130},-1),0.25,0.37,0.4,0.47))

---

Copy down and Paste special as values over the top of the orginals. Follow the descending pattern in the MATCH function and the acsending pattern for CHOOSE

thanks..
works wonderfully ..you saved me hours of work....
Just one note...in paste special i had to write 3% increase as 0.03..and i had to do the same with your formula...just in case someone else find this post usefull
nafri,,

[Dave Hawley]

Yep, .03 IS 3% a percentage is part of 1.