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
Hello Lira
Welcome to teh forum
your just missing a close parentheses ) here:
D2 <=19 ) ,2
the red one
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STARicon to say thank you -even the given idea/solution didn't really solve your queries. The time given to you deserves a small gratitude anyway.
Dare to give a pencil to a child. http://www.blackpencilproject.org/
OH thanks !!!! never noticed.... muah muah... thanks savior!!! it actually worked!!!!Originally Posted by vlady
phew.... never thought that much simple...
Walang Anuman.
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STAR
Dare to give a pencil to a child. http://www.blackpencilproject.org/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks