Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

trying to see if there's a formula for what i need. i'll have a column of numbers and want the next column to say either "1" "2" or "3" based on the value of the prior column. tried playing witht the if function, but that seems to only have 2 answers
Solved by B. H. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 25/04/2018 - 02:00
Hi there!
Excelchat Expert 25/04/2018 - 02:00
I think you're on the right track with your IF logic... might you be able to make a quick example of how the sheet is set up in the google sheet over there ------------>
Excelchat Expert 25/04/2018 - 02:01
Perfect and then let me know your desired logic and I will make it happen!
User 25/04/2018 - 02:02
basically looking for a formula to say if the number in A is less than -2000, put 1 in B, between -2000 and 0, put 2 in B, anything greater than 0, put 3 in B
Excelchat Expert 25/04/2018 - 02:02
Excelchat Expert 25/04/2018 - 02:02
You were definitely right with your IF function - but we can use IFS instead
Excelchat Expert 25/04/2018 - 02:03
Let me create it and you can copy to your sheet and see if it works.
Excelchat Expert 25/04/2018 - 02:05
Try this:
Excelchat Expert 25/04/2018 - 02:05
User 25/04/2018 - 02:07
so i wouldn't have to set a range necessarily for "2". if it's less than 2,000, the first if takes precedent and it'll put a 1?
Excelchat Expert 25/04/2018 - 02:07
You got it
User 25/04/2018 - 02:07
perfect, thanks!
Excelchat Expert 25/04/2018 - 02:08
less than -2000
Excelchat Expert 25/04/2018 - 02:08
My pleasure!
Excelchat Expert 25/04/2018 - 02:08
Feel free to ping us back if you need further assistance - always happy to help!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc