Hi out there, I didn't know how to look this up so sorry if it's a repeat. Here is the issue. I have two sets of data - one from a questionnaire at the beginning of the semester and one at the end. I have been asked to examine the data to see if we can pull any valuable information from it. I was thinking very simply, if a > b then c, if a < b then d, if a = b then e. Thoughts, ideas?
Thanks!
"very simply, if a > b then c, if a < b then d, if a = b then e. Thoughts, ideas?
"
what are those a and b are they cell names . it should be cell addresses or cell names
here you enter some numbers in cells A1 and B1 and type this formula in an empty cell and see what happens.
=IF(A1>B1,"c",IF(A1<B1,"d",IF(A1=B1,"e")))
There are a number of ways to achieve this depending on the structure/data.
Since you provide insufficient details to allow a precise solution to be developed, see of you can use this approach.
Let's assume cell A1 contains a value, say 5.
We might use: =LOOKUP(A1,{0,5,10},{"A","B","C"})
Where "A"."B","C" are values to show depending on the look up result.
See the Excel Help on the LOOKUP function for detailed explanation.
Depending on the complexity of the data, a look up table might be more useful.
Upload a sample workbook (sensitive data scrubbed/dummied) for a more accurate solution.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks