I want to compare two cells in MS excel.

June 13, 2011 at 14:01:20
Specs: Windows XP
I want to compare two cells...."is cell A larger or smaller than cell B" then display the result in cell C.

See More: I want to compare two cells in MS excel.

Report •


#1
June 13, 2011 at 14:04:24
Try this:

=IF(A1>B1,"A is larger then B","B is Larger than A")

MIKE

http://www.skeptic.com/


Report •

#2
June 13, 2011 at 15:15:36
Thanks, that was helpful.

Report •

#3
June 13, 2011 at 19:38:48
But what if they are equal?

The formula will return a big fat lie. ;-)

(Yes, I am aware that "equal" wasn't part of the original criteria.)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question