Excel question 2018.2353029e

[Zoob]

I'm no good with IF statements in Excel... So any help would be appreciated!

 

If I have a value in A1, How do I get B1 to show specific text based on ranges in A1?

 

For example, I want  B1 to say dog if A1 = 1 to 10, and I want it to say cat if A1 = 11 to 20 etc...

 

 I have 10 ranges (1-10, 11-20, 21-30 etc..)  - can they all be covered in the same conditional IF statement? 

[Senrab_nhoj]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Gethin]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited January 24, 2018 by Gethin

[Tobes Rafa]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[PhilM]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited January 24, 2018 by philmatthews

[Tobes Rafa]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here