title: How can I make IF ELSE type statement in excel formula bar?
body: <p>Id like to make nested IF statements to function like an IF/ELSE. It's not the most elegant solution but I want to just get it functioning before I can improve it. </p>
  
  <p>heres psuedocode of what I'm trying to do</p>
  
  <p>IF no ERROR do:
  If condition = TRUE Search b4 for criteria given and divide by 10000,
  If condition = FALSE, IF condition2 = TRUE, Search and b5 for criteria given and divide by 1000
  IF condition2 =False, then display "ERROR"
  If Error then display "". </p>
  
  <p>I put the following into the formula bar:</p>
  
  <p>=IFERROR(IF(CLIENT=TRUE,SEARCH(Search!$B$4,C6)+ROW()/100000,IF(WORK_ORDER=TRUE,SEARCH(Search!$B$5,D6)+ROW()/100000,"ERROR",)"")</p>
  
  <p>I get an error saying function has too many arguments. </p>