Excel 2007 : Multiple Condition

Hey Guys...

I'm encountering this kind of problem on how to make a multiple condition.... I used IF & AND but it always says error in function everytime i press enter to execute the formula

here's what i did...

=IF(AND(D2>=0, D2<=9),1, IF(AND(D2>=10, D2<=19,2,"")))

what i wanted is that if D2 is between 0 to 9 then the answer in D3 is 1...
or if D2 is between 10 to19 then the answer in D3 is 2

Thanks in advance ^^..

Please help me with the formula... i don't know which part causes the error

Originally Posted by vlady

Hello Lira
Welcome to teh forum

your just missing a close parentheses ) here:

D2 <=19 ) ,2


the red one

OH thanks !!!! never noticed.... muah muah... thanks savior!!! it actually worked!!!!

phew.... never thought that much simple...