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
|