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.