Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make an If-Then formula in Excel?
I am trying to make an Excel spreadsheet to calculate my productivity at
work. I would like to make a column that works like this: If I work X amount of these projects then that's Y% of my goal. But if I work X amount of these projects then that's Y% of my goal. At work we have different goals for different "Skill Levels", and you work all the Skill Levels each day. I would like to be able to put this into a formula. I would like to be able to type in, say, 3 (for Skill Level 3) and have that translate to 3.125% of my goal. And then on the next row I work a Skill Level 5 which is 2% of my goal. I want to be able to do this by entering in the Skill Level number, rather than the corresponding percentage. Is this possible? Thanks for any help you can give me! :) |
#2
|
|||
|
|||
Hi
An example: You enter the skill level into cell A1. When for skill level 1 the percentage is 5%, sor skill level 2 - 4%, ... , for skill level 5 - 1%, then you get it by formula =CHOOSE(A1;5%;4%;3%;2%;1%) The formula ignores fractional part of number in A1, and returns an error whenever integral part of number is <1 and number of percentages in formula. -- Arvi Laanemets (When sending e-mail, use address arvil<Attarkon.ee) "kdub1980" wrote in message ... I am trying to make an Excel spreadsheet to calculate my productivity at work. I would like to make a column that works like this: If I work X amount of these projects then that's Y% of my goal. But if I work X amount of these projects then that's Y% of my goal. At work we have different goals for different "Skill Levels", and you work all the Skill Levels each day. I would like to be able to put this into a formula. I would like to be able to type in, say, 3 (for Skill Level 3) and have that translate to 3.125% of my goal. And then on the next row I work a Skill Level 5 which is 2% of my goal. I want to be able to do this by entering in the Skill Level number, rather than the corresponding percentage. Is this possible? Thanks for any help you can give me! :) |
#3
|
|||
|
|||
Awesome, thank you so much! It worked. It took a little modifying as Excel
only would allow 29 variables and I have 35. But I made a little work around of putting skill levels 1-15 in one column and 16-35 in another. Also, on mine, I had to replace the semi-colons with commas, but other than that, the formula worked! :) "Arvi Laanemets" wrote: Hi An example: You enter the skill level into cell A1. When for skill level 1 the percentage is 5%, sor skill level 2 - 4%, ... , for skill level 5 - 1%, then you get it by formula =CHOOSE(A1;5%;4%;3%;2%;1%) The formula ignores fractional part of number in A1, and returns an error whenever integral part of number is <1 and number of percentages in formula. -- Arvi Laanemets (When sending e-mail, use address arvil<Attarkon.ee) "kdub1980" wrote in message ... I am trying to make an Excel spreadsheet to calculate my productivity at work. I would like to make a column that works like this: If I work X amount of these projects then that's Y% of my goal. But if I work X amount of these projects then that's Y% of my goal. At work we have different goals for different "Skill Levels", and you work all the Skill Levels each day. I would like to be able to put this into a formula. I would like to be able to type in, say, 3 (for Skill Level 3) and have that translate to 3.125% of my goal. And then on the next row I work a Skill Level 5 which is 2% of my goal. I want to be able to do this by entering in the Skill Level number, rather than the corresponding percentage. Is this possible? Thanks for any help you can give me! :) |
#4
|
|||
|
|||
Hi
"kdub1980" wrote in message ... Awesome, thank you so much! It worked. It took a little modifying as Excel only would allow 29 variables and I have 35. But I made a little work around of putting skill levels 1-15 in one column and 16-35 in another. Also, on mine, I had to replace the semi-colons with commas, but other than that, the formula worked! :) You can create a separate sheet, p.e. Levels, with a single-column skill levels table in range A1:A35. I advice to define this table a named range p.e. SkillLevels =Levels!$A$1:$A$35 (When you want, you can hide this sheet after that) Now the formula from my previous posting will look like =CHOOSE(A1,SkillLevels) -- Arvi Laanemets (When sending e-mail, use address arvil<Attarkon.ee) "Arvi Laanemets" wrote: Hi An example: You enter the skill level into cell A1. When for skill level 1 the percentage is 5%, sor skill level 2 - 4%, ... , for skill level 5 - 1%, then you get it by formula =CHOOSE(A1;5%;4%;3%;2%;1%) The formula ignores fractional part of number in A1, and returns an error whenever integral part of number is <1 and number of percentages in formula. -- Arvi Laanemets (When sending e-mail, use address arvil<Attarkon.ee) "kdub1980" wrote in message ... I am trying to make an Excel spreadsheet to calculate my productivity at work. I would like to make a column that works like this: If I work X amount of these projects then that's Y% of my goal. But if I work X amount of these projects then that's Y% of my goal. At work we have different goals for different "Skill Levels", and you work all the Skill Levels each day. I would like to be able to put this into a formula. I would like to be able to type in, say, 3 (for Skill Level 3) and have that translate to 3.125% of my goal. And then on the next row I work a Skill Level 5 which is 2% of my goal. I want to be able to do this by entering in the Skill Level number, rather than the corresponding percentage. Is this possible? Thanks for any help you can give me! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
How do figure excel formula out? | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |