Question description:
This user has given permission to use the problem statement for this
blog.
Need help with an IF statement. Please assist.
Solved by A. C. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
02/10/2018 - 07:41
Are you the same agent?
Excelchat Expert
02/10/2018 - 07:41
Hello. Welcome to Excelchat, I see that your question is about IF formula
User
02/10/2018 - 07:41
Or different?
Excelchat Expert
02/10/2018 - 07:41
I can help you with that problem.
User
02/10/2018 - 07:41
I'm attaching the latest file.
[Uploaded an Excel file]
Excelchat Expert
02/10/2018 - 07:41
I just worked on the conditional formatting related to currency.
User
02/10/2018 - 07:41
Must be modified in Excel and not Google Sheets to maintain conditional formatting
Excelchat Expert
02/10/2018 - 07:42
Yes, same agent.
User
02/10/2018 - 07:42
Ok
Excelchat Expert
02/10/2018 - 07:42
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
02/10/2018 - 07:42
Please tell me more on the problem you have with IF statement.
User
02/10/2018 - 07:42
No problem
User
02/10/2018 - 07:42
On the Proforma Invoice tab, under payments/credits.
Excelchat Expert
02/10/2018 - 07:43
Yes
User
02/10/2018 - 07:44
I want the payments/credits to be called Deposits Received if there is a value in K9 on the overview page
User
02/10/2018 - 07:44
And Payments/Credits if that value is 0 or blank
Excelchat Expert
02/10/2018 - 07:45
Ok. Understood. If K9 on Overview page is 0 or blank then "Payments/Credits" otherwise Deposits Received"
User
02/10/2018 - 07:45
Correct
Excelchat Expert
02/10/2018 - 07:45
Now that I understand your question, I’ll start the step-by-step. Give me a couple of minutes to work on this.
Excelchat Expert
02/10/2018 - 07:47
Here it is.
[Uploaded an Excel file]
Excelchat Expert
02/10/2018 - 07:47
I have used IF and OR function.
Excelchat Expert
02/10/2018 - 07:47
=IF(OR('Order Overview'!K9="",'Order Overview'!K9=0),"Payments/Credits","Deposits Received")
Excelchat Expert
02/10/2018 - 07:48
If(or(logical_test1,logical_test2), value_if_true, value_if_false)
Excelchat Expert
02/10/2018 - 07:48
Please review and let me know if you need further explanation on this or if you have any question regarding the query and solution I have provided.
User
02/10/2018 - 07:49
Looks good.
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.