| cardingtr |
Excel experts out there I have aquestion for you. I am trying to make an excel program so can figure out who needs to be cancelled from work based on:
1. Number of days/hours worked
2. Last date employee got cancelled.
I want more weight, 70% on number of hours/days worked vs. 30% last date cancelled in the point system.
I am supervising a number of employees and its always a headache to figure out whos who but if I can just punch in the days cancelled and number of hrs/days worked it helps a lot.
I'm not an excel expert so maybe someone here can help me out.
Thanks. |
|
|
| phins2rt |
| Would it just be (number of hours worked *.7)*(days since last cancellation * .3)? Or is it more complex than that? |
|
|
| paulp |
[QUOTE]Originally posted by cardingtr
[
I want more weight, 70% on number of hours/days worked vs. 30% last date canceled in the point system.
Have you tried the logic equation?
=if(A>B, A, " ")
If A is the 70% on number of Hr/ days, and B is the 30% of last date canceled, and you preferred A over B, the cell only show if value A>B otherwise it's blank.
Explain little more of the function that you want to do or PM me.
Paul |
|
|
| cardingtr |
Thanks for your replies. I used "DATEIF" formula to get the number of days since last cancel then used "Rank" and multiply them with corresponding percentages. I ended with point system who to cancel.
Its neat. |
|
|
|
