Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Clues to a 3-digit number: If you multiplied the mystery number by 100 the result would have a 4 in the ones place. There is a 2 in my number that is 11,000 the value of the 2 in 208.7 The mystery number has a 7 in the thousandths place.
Solved by F. C. in 27 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 10/11/2017 - 01:14
Helloo
User 10/11/2017 - 01:15
Hi
Excelchat Expert 10/11/2017 - 01:15
Is there any additional details available for this mystery?
User 10/11/2017 - 01:15
No
User 10/11/2017 - 01:16
The number is a decimal
Excelchat Expert 10/11/2017 - 01:17
you have any excel for this problem?
User 10/11/2017 - 01:19
kind of
Excelchat Expert 10/11/2017 - 01:19
can you share it?
User 10/11/2017 - 01:20
Well there is a 7 in the thousandths place
Excelchat Expert 10/11/2017 - 01:22
I'm not quite getting this.. is this an excel problem you have.. or a mathematical problem?
User 10/11/2017 - 01:23
My math teacher gave it to me for homework so I guess a mathematical problem
Excelchat Expert 10/11/2017 - 01:24
ohhh.. ok.. this help sessions are more for excel problem...
Excelchat Expert 10/11/2017 - 01:24
will give some try for solving.. this..
Excelchat Expert 10/11/2017 - 01:25
any further clue as how many digit after the decimal?
User 10/11/2017 - 01:26
It says the number is a 3 digit number so 3 digits behind the decimal
Excelchat Expert 10/11/2017 - 01:31
are you sure.. its 3 digit?.. b'cos as per the clue.. "The mystery number has a 7 in the thousandths place"...
Excelchat Expert 10/11/2017 - 01:31
so in that case it should be 4 digit..
Excelchat Expert 10/11/2017 - 01:33
i think the number is 0.247
Excelchat Expert 10/11/2017 - 01:34
Hello are you there
User 10/11/2017 - 01:35
yes
Excelchat Expert 10/11/2017 - 01:36
do you just need the number
Excelchat Expert 10/11/2017 - 01:36
0.247?
User 10/11/2017 - 01:37
Yes but does the result number of 0.247 times 100 have a 4 in the ones place
Excelchat Expert 10/11/2017 - 01:37
24.7
Excelchat Expert 10/11/2017 - 01:38
0.247 * 100 = 24.7... so 4 is in ones place..
Excelchat Expert 10/11/2017 - 01:38
7 in the thousandths place... in decimal system.. it is 3rd number after decimal
Excelchat Expert 10/11/2017 - 01:38
so remaining 2 will come 1st
User 10/11/2017 - 01:39
So your saying the result number us 0.247
Excelchat Expert 10/11/2017 - 01:39
s
User 10/11/2017 - 01:40
* Is
Excelchat Expert 10/11/2017 - 01:40
Yes
User 10/11/2017 - 01:41
Thanks for helping me
Excelchat Expert 10/11/2017 - 01:41
np..
Excelchat Expert 10/11/2017 - 01:41
is that all
User 10/11/2017 - 01:41
yes
Excelchat Expert 10/11/2017 - 01:41
please click on end sesion and leave a feedback
Excelchat Expert 10/11/2017 - 01:41
Session

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc