more than 4 if functions?
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
|