Jul 08 2021 12:28 AM
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?
Thanks!
Jul 08 2021 01:00 AM
SolutionJul 08 2021 01:20 AM
Alternatively, if you run Excel 2019 or 365:
=IFS(E26 < 8,"Few", E26 <= 14,"Some", TRUE,"Many")
Jul 08 2021 02:09 AM
Jul 08 2021 04:22 AM
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.
Jul 08 2021 01:00 AM
SolutionPlease try this...
=IF(E26<8,"Few",IF(E26<=14,"Some","Many"))