P
Pullge
I am trying to create a formula that will assign a value such as 1, 2 or 3
based on the cell percentage value.
If the cell is < 70.00% then it's value will be a 1
If the cell is between 70.01% and 83.00% then it's value will be 2
If the cell is between 83.01% and 89.00% then the value will be 3
The cell currently will pull data from another source and I have a new sheet
that needs to be able to look at the current percentage and then take the
value of 1 or 2 or 3 and then multiply it by a set variable.
So if Cell C3 has a current value of 73.00% it would need to be assigned the
value of 1. Then the formula would need to take the value 1 and muliply it
by 2 to give me my final value of 2
I have tried many variables, but not able to get the syntax or formula
correct. Any help is most appreciated.
based on the cell percentage value.
If the cell is < 70.00% then it's value will be a 1
If the cell is between 70.01% and 83.00% then it's value will be 2
If the cell is between 83.01% and 89.00% then the value will be 3
The cell currently will pull data from another source and I have a new sheet
that needs to be able to look at the current percentage and then take the
value of 1 or 2 or 3 and then multiply it by a set variable.
So if Cell C3 has a current value of 73.00% it would need to be assigned the
value of 1. Then the formula would need to take the value 1 and muliply it
by 2 to give me my final value of 2
I have tried many variables, but not able to get the syntax or formula
correct. Any help is most appreciated.