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
[Solved] Help needed in changing cell values
[Solved] Help needed in changing cell values
Last edited by robleyd on Thu May 09, 2019 1:55 pm, edited 2 times in total.
Reason: Tag as Solved
Reason: Tag as Solved
OpenOffice 4.1.3, Windows 7
Re: Help needed in changing cell values
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:
In cell Lx:
Code: Select all
=IF(Ix < 1 ; 0.004 ; 0.005)
Re: Help needed in changing cell values
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
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
OpenOffice 4.1.3, Windows 7
Re: Help needed in changing cell values
Hey, I got it. I didn't take the I away. It is working now. Thanks a lot for helping me out here.
OpenOffice 4.1.3, Windows 7
Re: [Solved] Help needed in changing cell values
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
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
OpenOffice 4.1.3, Windows 7
Re: [Solved] Help needed in changing cell values
You need VLOOKUP; see [Tutorial] VLOOKUP questions and answers
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers