Using LEFT(Cell,#) as a condition in an IF statement
Posted by Melody on April 27, 2001 8:22 AM
I am trying to make the following formula work:
Now, I know that on this particular row, (LEFT($E8,2)) is 10, and if I type '10' in place of (LEFT($E8,2)), the formula works fine. However, I need it to read it row by row for me (I don't want to go and figure it out on 30000 rows!).
Can anyone help me?