Sportbike Addicts | Two Wheels... Our Drug of Choice

Sportbike Addicts | Two Wheels... Our Drug of Choice (http://sportbikeaddicts.com/forums/index.php)

- Off Topic (http://sportbikeaddicts.com/forums/forumdisplay.php?f=37)

- - excell (http://sportbikeaddicts.com/forums/showthread.php?t=9395)

Mike295

09-25-2009 12:48 PM

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

RCM78

09-25-2009 12:54 PM

you see that help menu? Use it.

Does this help?

http://office.microsoft.com/en-us/ex...CL100570551033

Mike295

09-25-2009 01:19 PM

i gotit.. =if(and(A2<B2,A2<C2,A2<D2,A2<E2),"Not Crossed","Crossed")

soda7o

09-25-2009 01:52 PM

vlook up ;)

ffejtable

09-25-2009 05:15 PM

spelling, its not something you excell at.

seriously... how do you spell something as trivial as excel wrong, especially when its staring you right in the face??

Cakes206

09-25-2009 05:19 PM

Quote:

Originally Posted by ffejtable (Post 103373)

spelling, its not something you excell at.

seriously... how do you spell something as trivial as excel wrong, especially when its staring you right in the face??

This is Mike, the whole misspelled shoutbox thread is basically dedicated to him :crackup:

All times are GMT -4. The time now is 04:39 AM.