Excel - IF Function Problem - Expert Solution

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

I need to create formula for where if the result is in negative needs Credit and if positive needs re-invoicing. Please help
Solved by I. Y. in 19 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 12/10/2018 - 02:04
Hi
Excelchat Expert 12/10/2018 - 02:04
Welcome to Excelchat!
Excelchat Expert 12/10/2018 - 02:05
I see that your question is about fixing formulas.
Excelchat Expert 12/10/2018 - 02:05
I can help you with that.
Excelchat Expert 12/10/2018 - 02:05
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.
Excelchat Expert 12/10/2018 - 02:05
Let me ask you a couple of quick questions to make sure I fully understand your problem.
Excelchat Expert 12/10/2018 - 02:06
Based on what you’ve shared, you need to implement a if statement, right?
Excelchat Expert 12/10/2018 - 02:06
Am I right?
User 12/10/2018 - 02:08
no
Excelchat Expert 12/10/2018 - 02:08
Ok, Could you please give me a bit more context around the problem?
User 12/10/2018 - 02:08
I need a simple formula so that once u entered all the details it will tell you if need credit note or need reinvoicing
Excelchat Expert 12/10/2018 - 02:09
Sure, I can help you with that.
Excelchat Expert 12/10/2018 - 02:09
Could you please share the workbook with me? So that I can take a detailed look.
User 12/10/2018 - 02:09
Invoice No Product code Qty ordered Qty invoiced Qty received Descrencies CN/Re-inv 368819S 35261 2 4 2 -2
User 12/10/2018 - 02:10
hang on
Excelchat Expert 12/10/2018 - 02:10
I am really sorry but will it be possible for you to attach the workbook
Excelchat Expert 12/10/2018 - 02:10
Sure.
User 12/10/2018 - 02:11
[Uploaded an Excel file]
Excelchat Expert 12/10/2018 - 02:12
Ok, so I see two columns with data. Could you please tell me what is this data?
Excelchat Expert 12/10/2018 - 02:13
Hi, Are you there?
Excelchat Expert 12/10/2018 - 02:23
Please use "if " formula to apply your condition.
Excelchat Expert 12/10/2018 - 02:24
The syntax is as follows
Excelchat Expert 12/10/2018 - 02:24
For example, =IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2).
Excelchat Expert 12/10/2018 - 02:24
Do you have any other questions about this problem and the solution?
Excelchat Expert 12/10/2018 - 02:24
Thanks for coming to Excelchat. Feel free to leave any comments or feedback. Have a nice 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.