[Solved] Help needed in changing cell values

[Arshad]

Hi all, I am facing some difficulties in getting my spreadsheet works the way I wanted it. I needed my percent allocation change from 0.4% to 0.5% if target given hit 100% OR more, refer pic below. I hope you guys understand the message that I am trying to convey, as English isn't my mother tongue . See attachment.

Thanks in advance

Arshad

[keme]

Assuming you also want to increase the sales commision for those achieving exactly 100%. Try the following formula (replace "x" with the row number of the cell where you have the formula).

In cell Lx:

Code: Select all

=IF(Ix < 1 ; 0.004 ; 0.005)

[Arshad]

Hi Keme,

Thanks for the prompt reply, it almost works. Lol. The thing is, the last cells doesn't change value to 0.5%and remains at 0.4% after hitting 100% or more.

But hey, thanks a lot for your help. And do let me know if there is anything that I may have misunderstood. Or any other way to achieve that.

Thanks a lot

[Arshad]

Hey, I got it. I didn't take the I away. It is working now. Thanks a lot for helping me out here.

[Arshad]

Hi, I need all of your help again, this time in bigger range of data.

Say if you make certain percentage of given goal, target cells recognized that and change values accordingly,

Example data as follows,

Less than 70% - 0
70% goal achieved - 400
80% goal achieved - 500
90% goal achieved - 700
100% goal achieved - 900
110% goal achieved - 1200
120% goal achieved - 1500
130% and above achieved - 2000

Thanks a lot for all your help people.

Arshad

[robleyd]

You need VLOOKUP; see [Tutorial] VLOOKUP questions and answers