if a < b then c, if a > b then d

[awelsh]

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!

[venkat1926]

"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")))

[Palmetto]

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.