IFERROR - Too many arguments

[jshephe2]

I just can't fix my error on this. I am using this formula in a drop down situation and the rows of data will be different each time. So if there isn't data, I want the error show a blank cell.

=IFError((LEFT(G6,3)="OC1"),"Omnicell In-House",IF((LEFT(G6,3)="CMS"),"MedOne",IF((LEFT(G6,3)="001"),"CreekRidge","UNKNOWN")),"")

But it continues to tell me that I have too many arguments. I have played with it for 30 min.

Thank you.

[shirleyxls]

You have an IF missing:

=IFERROR(IF(LEFT(G6,3)="OC1","Omnicell In-House",IF(LEFT(G6,3)="CMS","MedOne",IF(LEFT(G6,3)="001","CreekRidge","UNKNOWN"))),"")

and some excess brackets

[jshephe2]

Thank you!

[AB33]

=IFERROR(IF((LEFT(G6,3)="OC1"),"Omnicell In-House",IF((LEFT(G6,3)="CMS"),"MedOne",IF((LEFT(G6,3)="001"),"CreekRidge","UNKNOWN"))),"")

[shirleyxls]

Pleasure!

Don't forget to mark your thread as SOLVED using the Thread Tools at the top of the post