[Solved] Help needed in changing cell values

Discuss the spreadsheet application

[Solved] Help needed in changing cell values

Postby Arshad » Thu May 09, 2019 7:58 am

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
Attachments
Capture.PNG
Last edited by robleyd on Thu May 09, 2019 1:55 pm, edited 2 times in total.
Reason: Tag as Solved
OpenOffice 4.1.3, Windows 7
Arshad
 
Posts: 4
Joined: Thu May 09, 2019 7:36 am

Re: Help needed in changing cell values

Postby keme » Thu May 09, 2019 8:21 am

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   Expand viewCollapse view
=IF(Ix < 1 ; 0.004 ; 0.005)
User avatar
keme
Volunteer
 
Posts: 3286
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Help needed in changing cell values

Postby Arshad » Thu May 09, 2019 9:47 am

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
OpenOffice 4.1.3, Windows 7
Arshad
 
Posts: 4
Joined: Thu May 09, 2019 7:36 am

Re: Help needed in changing cell values

Postby Arshad » Thu May 09, 2019 9:56 am

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
Arshad
 
Posts: 4
Joined: Thu May 09, 2019 7:36 am

Re: [Solved] Help needed in changing cell values

Postby Arshad » Fri May 10, 2019 8:03 am

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
OpenOffice 4.1.3, Windows 7
Arshad
 
Posts: 4
Joined: Thu May 09, 2019 7:36 am

Re: [Solved] Help needed in changing cell values

Postby robleyd » Fri May 10, 2019 8:11 am

Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3057
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Calc

Who is online

Users browsing this forum: No registered users and 29 guests