Nested Function Difficulty

[bmst1972]

Dear Mr. Excel:

I am a schoolteacher who is trying to create a multiple-choice auto grader. However, I am having difficulty created a nested function. Can you let me know what is wrong with the following?: =IF(ISBLANK(E10),"",ISNUMBER(SEARCH("B",E10)),"1","0")

Sincerely,
Robert McLeod

 

[RoryA]

You're missing a second IF function:

=IF(ISBLANK(E10),"",IF(ISNUMBER(SEARCH("B",E10)),1,0))

 

[wideboydixon]

IF(ISBLANK(E10),"",IF(ISNUMBER(SEARCH("B",E10)),"1","0"))

You need another IF() to deal with the ISNUMBER()

WBD

 

[wideboydixon]

  ,_-~~~-,    _-~~-_
 /        ^-_/      \_    _-~-.
|      /\  ,          `-_/     \
|   /~^\ '/  /~\  /~\   / \_    \
 \_/    }/  /        \  \ ,_\    }
        y  /  /~  /~  |  y   \   |
       /   | {q) {q)  |  |    \_/
       |   \  _===_  /   |
       /  >--{     }--<  \
     /~       \_._/       ~\
    /    *  *   y    *      \
    |      * .: | :.*  *    |
    \    )--__==#==__--     /
     \_      \  \  \      ,/
       '~_    | |  }   ,~'
          \   {___/   /
           \   ~~~   /
           /\._._._./\
          {    ^^^    }
           ~-_______-~
            /       \

wbd

 

[shg]

Or

=IF(ISBLANK(E10),"", --ISNUMBER(SEARCH("B",E10)))

 

[bmst1972]

Thanks...You helped me to realize I misplaced a right parentheses symbol.