=IF(ISBLANK(B210),"",IF(LEFT(P210,2)="SD","Slave Driven",IF(R210="-","","480v AC")))
If I use this formula in an blank worksheet w/bogus data, I don't get an error;it looks like it works fine. When I enter it into a database from an outside source i.e origingal equipment manuf. Excel kicks out #VALUE error when LEFT(P210,2) is not "SD". Any ideas/help. I'll be using this formula in multiple worksheets w/lots of data to populate col AK w/"","Slave Driven" or "480v AC".
If I use this formula in an blank worksheet w/bogus data, I don't get an error;it looks like it works fine. When I enter it into a database from an outside source i.e origingal equipment manuf. Excel kicks out #VALUE error when LEFT(P210,2) is not "SD". Any ideas/help. I'll be using this formula in multiple worksheets w/lots of data to populate col AK w/"","Slave Driven" or "480v AC".
