excell - Sportbike Addicts

Mike295 · 09-25-2009, 12:48 PM

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

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