Hi Folks:

I'm trying to develop a formula that says if the first 2 characters of a
cell are not either a CU, or a GU, return the word "Tube"

The formula below yields a #VALUE!

=IF(E7<"CU*","Tube","Module")*OR(IF(E7<"GU*","Tu be","Module"))

Any help appreciated

Steve

Try this then:

=IF(OR(LEFT(E7,2)="CU",LEFT(E7,2)="GU"),"Module"," Tube")

I think I've got the negative logic right!

Hope this helps.

Pete

Maybe this mod to cover a blank cell......

=IF(OR(LEFT(E7,2)="CU",LEFT(E7,2)="GU"),"Module",I F(E7="","","Tube"))

Vaya con Dios,
Chuck, CABGx3



"Pete_UK" wrote:

Try this then:

=IF(OR(LEFT(E7,2)="CU",LEFT(E7,2)="GU"),"Module"," Tube")

I think I've got the negative logic right!

Hope this helps.

Pete

=IF(OR(LEFT(E7,2)="CU",LEFT(E7,2)="GU"),"Module"," Tube")

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=544673