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
To upload a file, please click on the paperclip icon.
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
I need a little more info, what are we calculating again?
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.
