I'm trying to create a formula using numbers that will create several options from one number. If cell can be anywhere between 1 to 100 and if they score 1 to 25, they receive score 2, if they score 26 to 50, they score 3 and if they score 51 to 100 they receive 4. Just need simple formula. Thanks.
You should use the % notation in the IFS function if you keep the % notation in column AA, as I have presented in the second image.
Paul.
What is the format of the content of each cell in column AA: Percentages? or Numbers? Or Text? Or a result from a formula using the "&" operator for adding the "%" symbol?
Paul.
It works here on this computer. It should work on yours.
Thank you. It was the Rounding that made everything click.
Badunit wrote:
Stfflspl mistyped the percentage to number equivalence in an earlier post. 70% =0.7 not 0.07. …
Thanks for correcting my mistake.
Paul.
Thank you Stffpspl for helping me through this.
Numbers formula with multiple options
