Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If function
I have been on here previously and successfully found an answer to a query
about the IF function. Unfortunately it only works partially and I can't find my original post, so here goes! I produce weekly statistics by team using data extracted by SQL. There are 21 managers in total and using the IF function I am trying to automatically ascribe a team 'value' to quickly produce stats by team. However, I hit a snag when trying to ascribe a value for more than 8 indiciduals in that the formula doesn't work so the formula reads =IF(A1="Name of Manager","Name of Team,IF(A1="Name of Manager,"Name of Team)) and so on until I try to add a ninth manager name/team. Is there any way round this or is it possible to use OR in there as some of the 21 managers actually work within the same section and so, would have the same value ascribed. Any help would be greatly appreciated as currently, I am having to filter by manager name and then ascribe the value manually and quite frankly, life's too short! Cheers David |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If function
Hi David
IF function has a limit of 7 in a formula, although I understand the latest version can do 27. It would be far simpler if you used a VLOOKUP table. Type VLOOKUP in help for examples, or easier, do a search on this site for VLOOKUP HTH Michael M "David Platt" wrote: I have been on here previously and successfully found an answer to a query about the IF function. Unfortunately it only works partially and I can't find my original post, so here goes! I produce weekly statistics by team using data extracted by SQL. There are 21 managers in total and using the IF function I am trying to automatically ascribe a team 'value' to quickly produce stats by team. However, I hit a snag when trying to ascribe a value for more than 8 indiciduals in that the formula doesn't work so the formula reads =IF(A1="Name of Manager","Name of Team,IF(A1="Name of Manager,"Name of Team)) and so on until I try to add a ninth manager name/team. Is there any way round this or is it possible to use OR in there as some of the 21 managers actually work within the same section and so, would have the same value ascribed. Any help would be greatly appreciated as currently, I am having to filter by manager name and then ascribe the value manually and quite frankly, life's too short! Cheers David |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If function
Thanks Michael but I haven't got a clue about using the VLOOKUP function.
I've had a look at Help and although it's useful if you know what you're doing, I'm a real novice here! Would it be possible to give me an example of how it would look and then I'll have another go? Cheers David "Michael M" wrote: Hi David IF function has a limit of 7 in a formula, although I understand the latest version can do 27. It would be far simpler if you used a VLOOKUP table. Type VLOOKUP in help for examples, or easier, do a search on this site for VLOOKUP HTH Michael M "David Platt" wrote: I have been on here previously and successfully found an answer to a query about the IF function. Unfortunately it only works partially and I can't find my original post, so here goes! I produce weekly statistics by team using data extracted by SQL. There are 21 managers in total and using the IF function I am trying to automatically ascribe a team 'value' to quickly produce stats by team. However, I hit a snag when trying to ascribe a value for more than 8 indiciduals in that the formula doesn't work so the formula reads =IF(A1="Name of Manager","Name of Team,IF(A1="Name of Manager,"Name of Team)) and so on until I try to add a ninth manager name/team. Is there any way round this or is it possible to use OR in there as some of the 21 managers actually work within the same section and so, would have the same value ascribed. Any help would be greatly appreciated as currently, I am having to filter by manager name and then ascribe the value manually and quite frankly, life's too short! Cheers David |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If function
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If function
Have a look here for an example that Chuck posted to a similar question
http://www.microsoft.com/office/comm...xp=&sloc=en-us HTH Michael M "David Platt" wrote: Thanks Michael but I haven't got a clue about using the VLOOKUP function. I've had a look at Help and although it's useful if you know what you're doing, I'm a real novice here! Would it be possible to give me an example of how it would look and then I'll have another go? Cheers David "Michael M" wrote: Hi David IF function has a limit of 7 in a formula, although I understand the latest version can do 27. It would be far simpler if you used a VLOOKUP table. Type VLOOKUP in help for examples, or easier, do a search on this site for VLOOKUP HTH Michael M "David Platt" wrote: I have been on here previously and successfully found an answer to a query about the IF function. Unfortunately it only works partially and I can't find my original post, so here goes! I produce weekly statistics by team using data extracted by SQL. There are 21 managers in total and using the IF function I am trying to automatically ascribe a team 'value' to quickly produce stats by team. However, I hit a snag when trying to ascribe a value for more than 8 indiciduals in that the formula doesn't work so the formula reads =IF(A1="Name of Manager","Name of Team,IF(A1="Name of Manager,"Name of Team)) and so on until I try to add a ninth manager name/team. Is there any way round this or is it possible to use OR in there as some of the 21 managers actually work within the same section and so, would have the same value ascribed. Any help would be greatly appreciated as currently, I am having to filter by manager name and then ascribe the value manually and quite frankly, life's too short! Cheers David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |