How do I write "begins with"?
=IF(LEFT(B3,8)="Computer",B3,0)
"Terri" wrote:
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
|