BR
asked on
simple excel formula
Dear Experts,
=IF(LEFT(D2;1)=5;TRUE;FALS E)
I want to check, if the first letter of D1 is 5, I want to write TRUE otherwise FALSE
what is wrong with my formula?
=IF(LEFT(D2;1)=5;TRUE;FALS
I want to check, if the first letter of D1 is 5, I want to write TRUE otherwise FALSE
what is wrong with my formula?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The reason why your original was not working is probably because the contents of D1 are text rather than a number. Eventhough you are only looking at the first character and it is a number the fact that it has come from a text string it will be recognised as text.
If you want literally just a TRUE or FALSE result you don't need the IF statement:
=LEFT(D2;1)="5"
Thanks
Rob
If you want literally just a TRUE or FALSE result you don't need the IF statement:
=LEFT(D2;1)="5"
Thanks
Rob
ASKER
Thank you Rob Henson,
it's a beautiful answer
it's a beautiful answer
ASKER