Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
s boak
 
Posts: n/a
Default Formula Help

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