Excel - IF Function Problem - Expert Solution

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

I have an excel sheet that everyone in the company uses for Purchase Orders. It has always worked and for everyone else it is still working except on my computer EVEN IF I USE THE SAME ONE THEY HAVE. what could be going wrong? We have a column for price, then discount, then quantity. it used to always add the total after the quantity and is no longer doing so. Please help!!
Solved by M. J. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 20/09/2018 - 10:29
Hi, welcome to Got it Pro-Excel!
Excelchat Expert 20/09/2018 - 10:30
Let me ask you a couple of quick questions to make sure I fully understand your problem.
Excelchat Expert 20/09/2018 - 10:31
First, will you be able to send me the file so I can test it from my end?
User 20/09/2018 - 10:32
User 20/09/2018 - 10:32
Excelchat Expert 20/09/2018 - 10:32
Is this the actual file that all of you are using?
User 20/09/2018 - 10:33
It is a copy as the original template can not be typed in. everyone clicks "make a copy" of the origial
User 20/09/2018 - 10:33
Excelchat Expert 20/09/2018 - 10:33
Ok, noted. Give me a moment.
User 20/09/2018 - 10:33
It is working for everyone except me. Sometimes it will work for me on the first few lines and then towards the bottom stops adding
User 20/09/2018 - 10:34
Thank you!
Excelchat Expert 20/09/2018 - 10:34
I don't have access to the file. Kindly allow everyone to access it, thank you.
User 20/09/2018 - 10:35
User 20/09/2018 - 10:35
Ok that should work
Excelchat Expert 20/09/2018 - 10:35
Ok, I made a copy for myself so I can edit it.
Excelchat Expert 20/09/2018 - 10:35
Give me a moment to analyze your file.
Excelchat Expert 20/09/2018 - 10:35
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
User 20/09/2018 - 10:36
Excelchat Expert 20/09/2018 - 10:36
Ok, this worksheet looks simple. Can you tell me more about your problem, step by step.
User 20/09/2018 - 10:38
When I put in unit price I then need to add the quantity. After adding quantity it should put the total on the right side, as well as add to the total at the bottom of the page. It is no longer doing that for me. Also- sometimes it will do it on the first few lines but then will stop halfway down and will no longer add the total
Excelchat Expert 20/09/2018 - 10:38
Ok, let me try that on my end.
User 20/09/2018 - 10:39
Most times when it does this, the font also turns Red out of nowhere. Or I will type in quantity, it will not add to the total, I will then delete quantity and then it will add whatever total it should have been but quantity will show 0
Excelchat Expert 20/09/2018 - 10:39
It's working fine with me. I tried 3 lines.
User 20/09/2018 - 10:40
That's what everyone at work is saying too. I have been using this same file for about a year with no issues. It started yesterday and I have not done anything differently.
Excelchat Expert 20/09/2018 - 10:41
Which browser are you using?
User 20/09/2018 - 10:41
Microsoft Edge
Excelchat Expert 20/09/2018 - 10:41
Do you have any other browsers aside from Microsoft Edge?
User 20/09/2018 - 10:41
No, But I can download a different one if that will make a difference
Excelchat Expert 20/09/2018 - 10:42
Yes, I'm thinking it's your cookies and temporary internet files. Let's see if that'll work. Try downloading Google Chrome.
User 20/09/2018 - 10:42
Ok, I will do that. Thank you.
Excelchat Expert 20/09/2018 - 10:42
Let me know once your downloaded Google Chrome and tested your sheet if the problem persists.
Excelchat Expert 20/09/2018 - 10:43
I'll wait here. Make sure to extend our session when our timer hits below 3-minute mark.
Excelchat Expert 20/09/2018 - 10:47
Hi, kindly extend our session from your end so we can continue to support your problem.
User 20/09/2018 - 10:47
Ok, it appears to be working much better now.
Excelchat Expert 20/09/2018 - 10:47
Thank you. Let me know if you're done testing it via Google Chrome.
User 20/09/2018 - 10:47
Thank you for your help!!
Excelchat Expert 20/09/2018 - 10:47
Oh ok, is it working as expecteD?
User 20/09/2018 - 10:48
Excelchat Expert 20/09/2018 - 10:48
Excelchat Expert 20/09/2018 - 10:48
That's great.
Excelchat Expert 20/09/2018 - 10:48
Would there be anything else I can assist you with regards to the original question and the solution provided?
User 20/09/2018 - 10:48
No, that was all. thanks again
Excelchat Expert 20/09/2018 - 10:48
If that's all, I'd like to wish you have a very nice day ahead of you and we'd love to hear from you again. Feel free to leave a rating and comment at the end of this session. Thank you for using Got it Pro-Excel!

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
The Allstate Corporation
United Parcel Service
Dell Inc