# Excel - IF Function Problem - Expert Solution

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
User 02/10/2018 - 07:41
I'm attaching the latest 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.
Excelchat Expert 02/10/2018 - 07:47
I have used IF and OR function.
Excelchat Expert 02/10/2018 - 07:47
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.

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.