Forum Discussion
Functions and formulars
Hi all, yes I am struggling to find the right formular for a problem, or to get it to work. I have a number in cell B14, which i want to return a value in cell B13. if B14 gives a value between 30 ...
=IFS(B14<9, "Yellow", AND(B14>=17, B14<=29), "Purple", AND(B14>=30, B14<=49), "Pink", TRUE, "No Match")
Yellow is less than 9
Purple is 17-29
Pink is 30-49
Anything outside those ranges will come back as "No Match". This should be pretty easy to edit in the future. Try out Co-pilot to help you create the formulas, you can type in exactly what you requested here and it would provide you what you need very quickly.