I should have said that if A1=29 or B1=17 then it needs to say 5. I don't
know how this worked but it did. Thanks for your help.
--
Thanks, Joy


"Pete_UK" wrote:

I think there are two other conditions you've not accounted for:

A1=29 and B1<17
A1<29 and B1=17

Each of these could be regarded as two conditions if you want to
distinguish between B117 and B1<17, and A129 and A1<29.

Anyway, yes you can use the IF function, along the lines of:

=IF(A1=29,IF(B1=17,5,"not
defined"),IF(A129,IF(B117,1,2),IF(B117,3,4)))

This assumes the second and fourth of your conditions are for B1<=17.

Hope this helps.

Pete

On Oct 1, 2:48 pm, 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