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

Hello,

I'm using Excel 2003 (yes, still) and I'm having trouble with the IF function.
I have a 13-digit number in E2, and in F2 I want the function to say "yes" if the 10th digit is 5.

The value in E2 is: 1211990335073
So I've tried using: =IF(MID(E2;10;1)=5;"yes";"no"). So obviously, it should say yes, but it doesn't. What am I doing wrong?

When you wrote incorrect functions, what did you learn about spreadsheet data?
Functions of spreadsheet - Guide
Transfer data from one excel worksheet to another automatically - Guide
Digital data transmission - Guide
We can’t give you access to this account or help with your request until we receive an accepted form of id that matches the information listed on the account. learn more about the types of id we accept in the help center: ✓ - Facebook Forum

2 replies

Answer 1 / 2

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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").

Answer 2 / 2

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

Hi MouseBouse

Another version, which could be used.

=IF(--MID(A1,9,1)=5,"yes","no")

Kevin

Similar discussions

Spreadsheet data

pendrive G:\ is not accessible I/O device error'

USB:\ is not accessible. Incorrect Function.

Instagram Account Hacked!

Excel Golf Skins Sheet

my computer cannot read SD card

Similar discussions

Subscribe To Our Newsletter!