Help with IF formula

Helen Coen

Struggling to write an IF formula and looking for some help please. Needs to work as follows:

If a cell is showing a number between 0-2, "Blue", if between 2.1-4 "Green", if between 4.1 -5 "Yellow", greater than 5 "Red"

Help appreciated

Ryan Sides

Hey Helen, just use nested if statements...

=if(Column@row >5, "Red", if(Column@row >= 4.1, "Yellow", if(Column@row >= 2.1 "Green", "Blue")))

Ryan Sides

Hey Helen, just use nested if statements...

=if(Column@row >5, "Red", if(Column@row >= 4.1, "Yellow", if(Column@row >= 2.1 "Green", "Blue")))

Helen Coen

oh that was easy! Thanks Ryan

Ryan Sides

You’re welcome! You’ll find you’ll use them all the time in SS.