I'm using Google Sheets and I want to display certain text based on the numerical value of another cell. I am a teacher trying to create an assignment where students have to find the best zombie apocalypse location, and they have to tally total zombie attacks through the first 4 days.
Based on each city's total attacks through 4 days, I want the next cell in the row to display 1 of 4 "City Statuses."
- 0-19 attacks should say "Low Risk,"
- 20-49 is "Medium Risk," 50-99 "High Risk" and
- 100+ attacks is "Evacuate Immediately".
I'm imagining a function that is basically like
if G2 < 20, write text "Low Risk";
if G2 > 19 & G2 < 50, write text "Medium Risk";
if G2 > 49 & G2 <100, write text "High Risk";
if G2 > 99, write text "Evacuate Immediately".
But I'm a newbie to any functions beyond the very basic and don't know how to put together the formula I need to do this.
I've gotten the conditional formatting down, but as far as I can tell that just changes colors. I want to display one of four possible strings of text based on a range of the numerical value of another cell.