Hello,
I am hoping someone could provide me with a solution to an excel challenge I am facing. I am trying to obtain a formula in where a cell provides me with a numerical score of say 1-5, based on what percentage the operational cost is compared to the total spend.
So if for example an entity has a operational cost of 4000 of a total spend of 1000000, that means there will be a 0,4% operational cost compared to the total spend and as such, the formula would automatically provide the designated cell with a numerical value of 1 since the categorisation illustrated here states that 0-10% operational cost should receive the value of 1.
Hopefully this is not as complicated as it appears to me.
Thank you.
I am hoping someone could provide me with a solution to an excel challenge I am facing. I am trying to obtain a formula in where a cell provides me with a numerical score of say 1-5, based on what percentage the operational cost is compared to the total spend.
So if for example an entity has a operational cost of 4000 of a total spend of 1000000, that means there will be a 0,4% operational cost compared to the total spend and as such, the formula would automatically provide the designated cell with a numerical value of 1 since the categorisation illustrated here states that 0-10% operational cost should receive the value of 1.
Hopefully this is not as complicated as it appears to me.
Thank you.