I tried it but it came back with a True answer for all of them and I need to
say either 1,2,3,4 or 5.
--
Thanks, Joy


"Max" wrote:

One guess ..

Try in say, C1:
=IF(COUNT(A1,B1)<2,"",IF(AND(A129,B117),1,IF(AND (A129,B1<17),2,IF(AND(A1<29,B117),3,IF(AND(A1<29 ,B1<17),4,IF(AND(A1=29,B1=17),5,""))))))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Joy" wrote:
I have 2 colums of numbers and I need to find out this criteria. Do I use
the If function?

A129 and B117 = 1
A129 and B1<17 = 2
A1<29 and B117 = 3
A1<29 and B1<17 = 4
A1=29 and B1=17 = 5
--
Thanks, Joy