If else formula

[storo1975]

I have data in a spreadsheet that consists of 3 columns
First column is a list of names, Second column is a number and the third column is empty. I want to input a formula that does the followiing:

If the contents of Column B is greater than or equal to 100, then enter the word Legends. If the contents of Column B is between 51 to 99, then enter the word Tough Enough. If the contents of column b is between 10 to 50, then enter the word Cruiserweight.

I got as far as this but got stumped:

=IF(B2 >= 100, "Legends", "Other")

Can anyone assist?

 

[RSXchin]

=IF(B2 >= 100, "Legends",IF(B2>50,"Tough Enough","Cruiserweight"))

 

[storo1975]

THATS AWESOME! it works perfectly. Thank you soo much

 

[RSXchin]

does it matter if it's less than 10?

then use this
=IF(B2<10,"Too few",IF(B2 >= 100, "Legends",IF(B2>50,"Tough Enough","Cruiserweight")))<table width="64" border="0" cellpadding="0" cellspacing="0"><tr height="20"><td style="height:15.0pt;width:48pt" width="64" height="20"></td> </tr></table>

 

[storo1975]

hmm good point ... anything less than ten "Not Qualified"

 

[RSXchin]

=IF(B2<10,"Not Qualified",IF(B2 >= 100, "Legends",IF(B2>50,"Tough Enough","Cruiserweight")))

 

[storo1975]

thanks again for all your help!

 

[delaneyjm]

Set up a small lookup table which will allow you to scale up more easily.

Excel Workbook
	A	B
1	Lookup Value	Result
2	23	Cruiserweight
3	87	Tough Enough
4	101	Legends
5	9	Not qualified
Sheet2