Hi Guys i need some help.
So the value that i have as follows
<10,000 = 30%
more than 10,000 but less than 20,000 = 50%
More than 20,000 but less than 100,000 = 70%
More than 100,000 = 90%
I want to create a formula that recognizes a cell's value and reflects the % as above when the value is as the conditions above
can someone help with the formula i cant find any online.
Hope my question is clear
So the value that i have as follows
<10,000 = 30%
more than 10,000 but less than 20,000 = 50%
More than 20,000 but less than 100,000 = 70%
More than 100,000 = 90%
I want to create a formula that recognizes a cell's value and reflects the % as above when the value is as the conditions above
can someone help with the formula i cant find any online.
Hope my question is clear