Compare 2 data set

G

Guest

Please help to provide a formula when compare A to B with results in col C.

Data example


A B Results C
1 2 Lower
2 2 No Change
3 2 Higher
 
D

David Biddulph

I assume there's a typo there in that B2 should presumably be B1? I guess
that what Mike intended was:
=IF(B1>A1,"Higher",IF(B1<A1,"Lower","No Change"))

But then the OP wanted the answers the other way round (A higher than B, not
B higher than A), so:
=IF(A1>B1,"Higher",IF(A1<B1,"Lower","No Change"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
How can I count deviations between two rows? 3
Lookup Formula 4
Compare arrays 5
Sumproduct seems off... HELP PLEASE! 3
Help With IF INDEX AND MATCH?? 3
Help with Formula IF INDEX AND MATCH 1
How do I calculate a weighted average and exclude the empthy cells 2

Top