Good Morning everyone,
I can't seem to figure this out but it seems pretty easy to me. I am trying to create a nested IF statement but can't get it to work properly.
What I want to say is
=IF(Audit!L8="x","no","",IF(Audit!M8="x","n/a","",))
It says i have too many arguments. Either L8 or M8 will be filled in. Never both.
=IF(Audit!L8="x","no",IF(Audit!M8="x","n/a",""))
=IF(Audit!L8="x","no",(IF(Audit!L9="x","n/a","")))
Oops... too late!
Thanks Everyone.
Alternative ways..
=IFERROR(INDEX({"no","n/a"},MATCH("x",L8:M8,0)),"")
=IFERROR(CHOOSE(MATCH("x",L8:M8,0),"no","n/a"),"")
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks