Excel - IF Function Problem - Expert Solution

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

if i calculate 1,486 x 10=1486 if i calculate1,4 x 10=14 What is wrong
Solved by F. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 28/05/2018 - 06:46
HI
User 28/05/2018 - 06:46
hi
Excelchat Expert 28/05/2018 - 06:46
It's pleasure to help you today.
Excelchat Expert 28/05/2018 - 06:46
I have referred your querey.
Excelchat Expert 28/05/2018 - 06:47
Can you please enter the following in the preview.
Excelchat Expert 28/05/2018 - 06:47
I will review them.
Excelchat Expert 28/05/2018 - 06:48
It is a different value. 14860.
Excelchat Expert 28/05/2018 - 06:48
How did you achieve 1486 only?
Excelchat Expert 28/05/2018 - 06:49
when you add comma, it is treated as text.
Excelchat Expert 28/05/2018 - 06:49
I have converted them to 1.48 instead.
User 28/05/2018 - 06:50
if i have three or more then its wrong
Excelchat Expert 28/05/2018 - 06:50
And there is a format, where comma can be added in thousand place.
Excelchat Expert 28/05/2018 - 06:50
that is not treated as text.
Excelchat Expert 28/05/2018 - 06:51
It is consider as number.
Excelchat Expert 28/05/2018 - 06:51
So, please check whether it is comma used as text or number format. Mostly it is number format, as you are multiplying with another number.
User 28/05/2018 - 06:52
why is it correct when using 1,4 & 1,48 bur wrong when using 1,486
Excelchat Expert 28/05/2018 - 06:53
1,48 can't be there.
Excelchat Expert 28/05/2018 - 06:53
As comma is used in thousand place.
Excelchat Expert 28/05/2018 - 06:53
1.48 is dot.
User 28/05/2018 - 06:54
ok thanks
Excelchat Expert 28/05/2018 - 06:54
You are welcome.
Excelchat Expert 28/05/2018 - 06:54
Please visit Got IT Pro.
Excelchat Expert 28/05/2018 - 06:54
Have a great day ahead. Please leave great review after ending the session.
User 28/05/2018 - 06:54
ok

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