Formula Help

S

s boak

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*","Tube","Module"))

Any help appreciated

Steve
 
P

Pete_UK

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
 
C

CLR

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

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

Vaya con Dios,
Chuck, CABGx3
 
Top