Hi all,
I have some problem with IF(AND formula.
I dont know where i am erring.Can anyone help? Where i am missing parenthesis or something else.
=IF(OR(C12<150,D9="NO DATA"),"NO",IF(AND(MIN(H15:H25)>L11,C11>(K11+(J11-K11)*100%),C11<(K11+(J11-K11)*150%),C11<(L11+(L11*1.5%)),"bad",IF(AND(MAX(G15:G25)<L11,C12<(J11-(J11-K11)*100%),C12>(J11-(J11-K11)*150%),C12>(L11-(L11*1.5%)),"good","Neutral"))
Thanks,
Netaji
You hadn't closed the AND() statements, or each of the IF() statements. i.e. not enough brackets. Try:
Please Login or Register to view this content.
Don't forget to ☆ me if I helped you!
It is often handy to add indents (or spaces) to a complex formula like this, so you can see where things fit and nest etc...
Formula:
Please Login or Register to view this content.
THis showed me you did not close the parentheses on both AND's, just before "bad" and just before "good
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks