Problems with IF-function...
Closed
MouseBouse
Kevin@Radstock
- Posts
- 1
- Registration date
- Sunday March 10, 2013
- Status
- Member
- Last seen
- March 10, 2013
Kevin@Radstock
- Posts
- 42
- Registration date
- Thursday January 31, 2013
- Status
- Member
- Last seen
- April 26, 2014
Related:
- Problems with IF-function...
- Functionality of wifi - Guide
- Which function can be used to directly bring automated data from one worksheet to another worksheet - Guide
- Functions of spreadsheet - Articles
- Function key stuck on - Guide
- Acer function keys not working - Guide
2 replies
rizvisa1
Mar 10, 2013 at 04:25 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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
Mar 11, 2013 at 01:56 AM
- Posts
- 42
- Registration date
- Thursday January 31, 2013
- Status
- Member
- Last seen
- April 26, 2014
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