# Excel - IF Function Problem - Expert Solution

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

I have IF function formula that doesn't calculate the end result correctly
Solved by T. J. in 28 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 09/07/2018 - 04:36
Welcome to excelchat.
User 09/07/2018 - 04:37
Am I speaking to someone?
Excelchat Expert 09/07/2018 - 04:37
Yeah, you are indeed.
User 09/07/2018 - 04:37
Hello
User 09/07/2018 - 04:37
I have a file I can upload
Excelchat Expert 09/07/2018 - 04:37
Hi, nice to have you here among us.
User 09/07/2018 - 04:37
But can't be shared of course
Excelchat Expert 09/07/2018 - 04:37
Excelchat Expert 09/07/2018 - 04:38
I understand that you data is sensitive.
Excelchat Expert 09/07/2018 - 04:38
You can share dummy data in stead.
User 09/07/2018 - 04:38
OK
Excelchat Expert 09/07/2018 - 04:39
Thanks, I'm waiting...
User 09/07/2018 - 04:39
sorry where do I upload it
User 09/07/2018 - 04:39
it'a a bit unclear
Excelchat Expert 09/07/2018 - 04:40
You can paste data in the preview sheet.
Excelchat Expert 09/07/2018 - 04:40
Alternatively you can send me a file directly by clicking on the paperclip icon.
User 09/07/2018 - 04:41
ok now
User 09/07/2018 - 04:42
2nd raw
Excelchat Expert 09/07/2018 - 04:42
Hmm, I'm listening...
User 09/07/2018 - 04:42
up to 125%b
User 09/07/2018 - 04:42
doesn't calculate propertly
Excelchat Expert 09/07/2018 - 04:43
User 09/07/2018 - 04:44
2nd raw up to 125%
User 09/07/2018 - 04:44
if function
User 09/07/2018 - 04:44
957 2,290 3,750
User 09/07/2018 - 04:44
2 numbers above are correct
User 09/07/2018 - 04:44
but the last one should be 503
User 09/07/2018 - 04:45
what it does it's taking the whole value up to 3750
User 09/07/2018 - 04:45
it doesn't calculate the difference
Excelchat Expert 09/07/2018 - 04:45
I'm sorry, difference of what and 125% of what?
User 09/07/2018 - 04:46
100% is 15,000
User 09/07/2018 - 04:46
125% is 18370
User 09/07/2018 - 04:47
I don't know if you can see formulas
Excelchat Expert 09/07/2018 - 04:47
I'm not able to see formula's.
User 09/07/2018 - 04:47
i see that time is running out
User 09/07/2018 - 04:48
is there any other way to do this?
Excelchat Expert 09/07/2018 - 04:48
Please send me the excel file directly.
Excelchat Expert 09/07/2018 - 04:49
We can extend time upto 1 hour if needed and unfortunately the chat box is the only way of communication.
User 09/07/2018 - 04:49
so where do I send it
Excelchat Expert 09/07/2018 - 04:49
click on the paperclip icon to upload a file which will be sent to me.
User 09/07/2018 - 04:50
ok
Excelchat Expert 09/07/2018 - 04:52
I'm waiting for the file...
Excelchat Expert 09/07/2018 - 04:52
Also you will be asked shortly to extend time, please select YES to extend.
Excelchat Expert 09/07/2018 - 04:55
Hello... Have you selected YES?
Excelchat Expert 09/07/2018 - 05:01
Hello, if you are there, you can reply in the preview window.
Excelchat Expert 09/07/2018 - 05:01
And you also can copy paste the formula there.
Excelchat Expert 09/07/2018 - 05:04
I guess you are not present.
Excelchat Expert 09/07/2018 - 05:04
Since I don't have adequate information and you are not also there, I'' close this chat now.
Excelchat Expert 09/07/2018 - 05:04
Have a great day!

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.