How do I write "begins with"?
I want my formula to say =if(B3 "begins with" Computer, B3, 0). So, I want
the formula to go to cell B3, if it begins with the word computer, (could be
computer desk, or computer monitor) then put it in the cell that I am in, if
not, put 0.
--
Terri
Amos Pewter
|