Allastaire
New Member
- Joined
- Oct 11, 2017
- Messages
- 2
Hello! I am at my wit's end trying to figure something out 
... OK so a quick synopsis of the problem:
I am designing a spreadsheet to track the progress of individual stores toward a goal of employee participation in a program. Depending on the employee participation percentage, a store receives differing amounts of points. The breakdown is as follows:
0 to <25% of employees participating: 0 points
25 to <50% of employees participating: 5 points
50 to <75% Participation: 15 Points
75% participation or more: 30 points
Store locations are organized in rows. Within the row for each store, I would like to have 1 cell where I will manually enter/update the store's employee participation percentage, then a cell 1 column over will automatically populate with the appropriate point value.
An example: Store #9999 Occupies Row 2, and A2 lists the store's name/number/etc. In B2, I would like to enter the store's employee participation percentage, and in C2 I would like to write a formula which, depending where the value of B2 lies in the range I specified above, outputs 0, 5, 15, or 30 points.
What type of function/formula accomplishes this? Thank you for any pointers!
... OK so a quick synopsis of the problem:I am designing a spreadsheet to track the progress of individual stores toward a goal of employee participation in a program. Depending on the employee participation percentage, a store receives differing amounts of points. The breakdown is as follows:
0 to <25% of employees participating: 0 points
25 to <50% of employees participating: 5 points
50 to <75% Participation: 15 Points
75% participation or more: 30 points
Store locations are organized in rows. Within the row for each store, I would like to have 1 cell where I will manually enter/update the store's employee participation percentage, then a cell 1 column over will automatically populate with the appropriate point value.
An example: Store #9999 Occupies Row 2, and A2 lists the store's name/number/etc. In B2, I would like to enter the store's employee participation percentage, and in C2 I would like to write a formula which, depending where the value of B2 lies in the range I specified above, outputs 0, 5, 15, or 30 points.
What type of function/formula accomplishes this? Thank you for any pointers!
