Problems with IF-function...
Closed
MouseBouse
Posts
1
Registration date
Sunday March 10, 2013
Status
Member
Last seen
March 10, 2013
-
Mar 10, 2013 at 03:02 PM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Mar 11, 2013 at 01:56 AM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Mar 11, 2013 at 01:56 AM
Related:
- When you wrote incorrect functions, what did you learn about spreadsheet data?
- Tmobile data check - Guide
- We limit how often you can post, comment or do other things in a given amount of time in order to help protect the community from spam. you can try again later. learn more ✓ - Facebook Forum
- We weren't able to confirm your identity from the video you submitted. you can submit a new video and we'll review it again. learn more. ✓ - Instagram Forum
- Functions of spreadsheet - Guide
- How to be offline in whatsapp when data is on - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 10, 2013 at 04:25 PM
Mar 10, 2013 at 04:25 PM
MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
You mid return is a string
=IF(MID(E2;10;1)="5";"yes";"no").
You mid return is a string
=IF(MID(E2;10;1)="5";"yes";"no").
Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Mar 11, 2013 at 01:56 AM
Mar 11, 2013 at 01:56 AM
Hi MouseBouse
Another version, which could be used.
=IF(--MID(A1,9,1)=5,"yes","no")
Kevin
Another version, which could be used.
=IF(--MID(A1,9,1)=5,"yes","no")
Kevin
