Hi all,
I have what is probably a very simple problem! I need to enter a numerical value in one cell which depending on if it's between 1-3, 4-10 or 11-15 will populate another cell to say either low, moderate or high.
I'm very much a newbie to formulas so I'd appreciate it if someone could tell me how to do this please? I use Office 2013.
Thank you in advance
one way would be =if(and(a2>0,a2<4),"low",if(and(a2>3,a2<11),"moderate","high"))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
another one you could use is =(LOOKUP(A1,{0,3,10},{"low","moderate","high"}))
But what happens if the Value is 3.5 or 10.5 etc?
If the numbers can only be integers, there are multiple ways to solve this..
Assume your numerical value is in cell A1, then use the below formula in a different cell where you want your answer..
OR
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by NeedForExcel; 05-04-2015 at 05:25 AM.
Cheers!
Deep Dave
If you have data in Cell A1
TRY =LOOKUP(A1,{-100000,1,4,11},{"","Low","Moderate","High"})
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
The numbers will always be whole.
Thanks for the super quick responses!
I'll be using this formula throughout the entire workbook so hopefully I won't need to manually change the 'A1' every formula to say 'A2,A3,A4 etc?
if I understand your last post, if you put either of my formulas in a location then drag down they will automatically change to the next location. So for a formula pointed to A1, if you drag down the formula (little box in the lower right corner of the cell) and drag that down, the formula will change to point to A2, then A3 etc. If you want to lock in the column you make the formula this way $A1, if you want to lock in the row, make the formula A$1, if you want to lock in that cell you make the formula $A$1. Hope that helps.
Thanks all, you've been amazingly helpful in such a short space of time
being new to this forum, for housekeeping, if the help you've gotten has solved your issue please take a couple moments and do the following. One, if the issue is solved please mark your post as solved using the thread tools drop down at the top of the post.
AND, if you are so inclined you can click "* Add Reputation" at the bottom of ANY and ALL of those who've taken the time to help you. It isn't mandatory but it is appreciated.
It is how we advance on this forum.
no worries, I've added the rep...will close successful now
Hello new to excel. I attached a sample spreadsheet. I would like a way to add an issue on the issue tab and it add the the total issues I have for that serial # on the info tab under issues. I would also like when I complete a Issue on the Issue tab that it removes itself from the issue column on the info page. Sorry if this is a lot or confusing but I would greatly appreciate the help. If it cant be done then thanks for trying.
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks