If Then statement with ranged values

Occasional Contributor

Hi! I am trying to construct a basic If Then statement in Excel where I would like a cell to output either "Few", "Some", or "Many" based on the value of another cell. It is simple to do such a statement with two outputs... e.g., =IF(E26<8,"Few","Many"), where if the value in E26 is less than 8, my cell will output "Few" and if it is greater, it will output "Many". A note that might be pertinent is that E26 is itself the product of a SUM formula.


But, if I wanted "Few" to correspond to <8, "Some" to correspond to 8-14, and "Many" to correspond to >14... what would I write?



4 Replies
best response confirmed by Noths760 (Occasional Contributor)


Please try this...




Alternatively, if you run Excel 2019 or 365:

=IFS(E26 < 8,"Few", E26 <= 14,"Some", TRUE,"Many")
Great! Thank you - this worked nicely.

You're welcome @Noths760! Glad it worked as desired.


Please take a minute to accept the post with the proposed Solution as a Best Response to mark your question as Solved.