jaybird2569
New Member
- Joined
- Sep 28, 2016
- Messages
- 22
Good morning,
I have a sales sheet that I use to calculate goals based on the seniority level of each salesperson. The formula checks the amount in column "D" against the appropriate goals in "D1-D15" and returns a rating. Currently I can't just drag the formula down the entire column as there are different levels and goals. I have to edit each formula based on seniority levels. What I would like to do is have the formula check in column "C" for the level then, based on that level, use the appropriate formula. Any help is greatly appreciated.
Here is an example of my sheet.
https://drive.google.com/open?id=0BzCAijneXT6JR3VsTDRmM3RRZTRBV21KVExrMGExTzJuVS1B
I have a sales sheet that I use to calculate goals based on the seniority level of each salesperson. The formula checks the amount in column "D" against the appropriate goals in "D1-D15" and returns a rating. Currently I can't just drag the formula down the entire column as there are different levels and goals. I have to edit each formula based on seniority levels. What I would like to do is have the formula check in column "C" for the level then, based on that level, use the appropriate formula. Any help is greatly appreciated.
Here is an example of my sheet.
Last edited: