Thread: excell
View Single Post

excell
Old 09-25-2009, 12:48 PM   #1
Mike295
sponge mike square pants
 
Mike295's Avatar
 
Mike295 is offline
Join Date: May 2005
Posts: 1,747
Default excell

I want to compare 5 columns of data (so A, B,C ,D,E) I want to compare Column A vrs the others. I wantto make sure that Column A is Lower in value. So If A2<b2 then = not crossed, if it is greater tehn = crossed.. ie. My formula looks like this “=IF(A2<B2,"Not crossed","Crossed")”
Now what I really want to do is compare column A to all the other columns. So If A is < B and C And D And E then show the result.. thee columns are not added up at all just compared
__________________
Quote:
Originally Posted by ant View Post
dude...being a jets fan is like having a fetish for getting kicked in the nuts
Quote:
[Today 09:17 AM] Cakes206: Miss one comma, all of a sudden become gay lmao
Quote:
[Today 12:54 PM] Ant: omg it made me want to be illiterate
  Reply With Quote