Hi everyone!
I'm a total newbie with Excel and need help with a formula.
Trying to work on a rank system, but get Value error or N/A most of the time.
What i need is, when cell B2 is between 1-179 pieces, cell C2 should turn to 3. Cell B3 between 180-259 should turn C3 to 3,1.
It's multiple because the rank system goes from 3-7,7.
Thanks in advance
I'm a total newbie with Excel and need help with a formula.
Trying to work on a rank system, but get Value error or N/A most of the time.
What i need is, when cell B2 is between 1-179 pieces, cell C2 should turn to 3. Cell B3 between 180-259 should turn C3 to 3,1.
It's multiple because the rank system goes from 3-7,7.
Thanks in advance