how to chek greater then equal numbers

J

Jai

Dear All
i'm having data's(numbers) in 6 column i want to know what is the greater
number and i'll give some example:-
A B C D E F G H I
are all Columns.
10 10 3 900 870 14.5 20 28 AA3A
50 55 5 1260 4260 28 30 10 AA2B
85 5 5 2160 3088 85 45 10 AA3C

48 48 10 6177 2287 86 10 20 AA5E
Here in above example D is greater than r equal to E then it has to check
ABC and again it has to check what is the greater than r equal to number in
Columns result is like to be(i'll take 1 row for example)( if it is D is
900it has to check in E column where and what is the greater number for 900
then it has to check ABC columns and again it has to chek the FGH then the I
columns data has to come) like 900 what is the greater number for 900 in E
Column 2287 is the next greater number FGH column greater number are there
then the I column data is AA5E )

for this what is the formula i have to use can use. if u give me this
formula to solve this problem.i'm always very greatfull to u......
I'M using Excel Version 2003.
but pls provide the result.
 
B

Bernard Liengme

Please re-state the question. It seems you need something like
=IF(D1>=E1,"ABC","XYZ")
best wishes
 

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

Top