Error in Formula(use of nested if, and, or functions)
Would appreciate help with the following formula in excel. Not sure if it's a formatting issue or if i've misused the 'if' 'and' 'or' functions as i've only just started to implement them in my work. The following gives me a parse error.
=IF((AND(D2<=25%)),A1,(IF((OR(D2>25%,D2<=35%)),A2,(IF((OR(D2>35%,D2<=45%)),A3,(IF((OR(D2>45%,D2<=55% )),A4,))(IF((OR(D2>55%,D2<=65%),A5,(IF((OR(D2>65%,D2<=75%),A6,(IF((OR(D2>75%,D2<=85%)),A7,A8)))))))) )))))
any help appreciated.
Your ORs should be ANDs....but there are simpler ways, try this
=INDEX(A1:A8,9-MATCH(D2,{100,85,75,65,55,45,35,25}%,-1))
Audere est facere
Thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks