**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.*