All solutions IF Expert Solution – Excel IF Problems

Excel - IF Function Problem - Expert Solution

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

I need to find out if the 2018 yearly sales goals were met if the yearly sales were $25,000 or more using an IF logical function and to set the formula to return a value of YES if met, and NO if not
Solved by A. A. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 14/10/2018 - 03:07
Hi, welcome to Got it Pro-Excel!
User 14/10/2018 - 03:07
Okay!
Excelchat Expert 14/10/2018 - 03:07
Let me ask you a couple of quick questions to make sure I fully understand your problem.
Excelchat Expert 14/10/2018 - 03:07
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. We also currently do not support VBA/Macro solutions.
User 14/10/2018 - 03:08
Okay
Excelchat Expert 14/10/2018 - 03:08
Based on what you’ve shared, you need an IF formula to check whether your value is above $25,000 and should return yes or no, do you believe that will address your problem?
User 14/10/2018 - 03:09
above or equal to
Excelchat Expert 14/10/2018 - 03:09
Ok, can you see our shared excel sheeT?
User 14/10/2018 - 03:09
yes
Excelchat Expert 14/10/2018 - 03:10
Can you see it change as I update it?
User 14/10/2018 - 03:10
Yes
Excelchat Expert 14/10/2018 - 03:11
Ok, I'll create the formula for you real quick.
User 14/10/2018 - 03:11
Okay
Excelchat Expert 14/10/2018 - 03:11
Ok, I've created the formula can you change the value in cell A2 to make sure the formula works as expected.
User 14/10/2018 - 03:12
To hat?
User 14/10/2018 - 03:12
What
Excelchat Expert 14/10/2018 - 03:12
Go to cell A2 and change the value too whatever value you like.
User 14/10/2018 - 03:13
It won't let me
Excelchat Expert 14/10/2018 - 03:13
Ok, I'll change it for you
User 14/10/2018 - 03:13
o
User 14/10/2018 - 03:14
ok
Excelchat Expert 14/10/2018 - 03:14
Did you see the samples I made?
User 14/10/2018 - 03:14
I see one
Excelchat Expert 14/10/2018 - 03:15
There you go, there are 4 samples.
User 14/10/2018 - 03:15
Ok
Excelchat Expert 14/10/2018 - 03:15
I'll send you the file and I'll walk you through the formula that I did.
User 14/10/2018 - 03:15
Ok
Excelchat Expert 14/10/2018 - 03:16
Here's the file.
[Uploaded an Excel file]
Excelchat Expert 14/10/2018 - 03:17
And this is the formula I used for cell C2 that you can easily copy and paste.
Excelchat Expert 14/10/2018 - 03:17
=IF(A2>=25000,"Yes","No")
Excelchat Expert 14/10/2018 - 03:17
The IF function can perform a logical test and return one value for a TRUE result, and another for a FALSE result. For example, to "pass" scores above 70: =IF(A1>70,"Pass","Fail"). More than one condition can be tested by nesting IF functions.
Excelchat Expert 14/10/2018 - 03:18
This is the syntax of IF Function.
Excelchat Expert 14/10/2018 - 03:18
=IF (logical_test, [value_if_true], [value_if_false])
Excelchat Expert 14/10/2018 - 03:18
logical_test - A value or logical expression that can be evaluated as TRUE or FALSE.
Excelchat Expert 14/10/2018 - 03:18
value_if_true - [optional] The value to return when logical_test evaluates to TRUE.
Excelchat Expert 14/10/2018 - 03:18
value_if_false - [optional] The value to return when logical_test evaluates to FALSE.
Excelchat Expert 14/10/2018 - 03:18
Let me break it down for you in our shared sheet.
User 14/10/2018 - 03:18
Ok
Excelchat Expert 14/10/2018 - 03:19
I aligned the syntax along with the formula that we used.
Excelchat Expert 14/10/2018 - 03:20
Our logical_test is A2>=25000
Excelchat Expert 14/10/2018 - 03:20
That means that it's checking cell A2 if the value inside is greater than or equals to 25000
Excelchat Expert 14/10/2018 - 03:21
If it meets the criteria or the value is greater than or equal to 25000 then the logical_test will return as TRUE and will proceed to calculate or return whatever we indicate in the value_if_true argument.
Excelchat Expert 14/10/2018 - 03:21
In our case, it's "Yes"
Excelchat Expert 14/10/2018 - 03:22
The reason why the word Yes is inside two double quotes is because we are saying to excel that this is a text.
User 14/10/2018 - 03:23
Ok
Excelchat Expert 14/10/2018 - 03:23
We can't put IF(A2>=25000,Yes,No) because Excel will try to read it as a function.
Excelchat Expert 14/10/2018 - 03:23
or invalid value.
Excelchat Expert 14/10/2018 - 03:24
Same goes with value_if_false, if our logical_test returns as false, then it will ignore value_if_true and will calculate or return the value or formula in value_if_false.
User 14/10/2018 - 03:24
Okay! Thank You!
Excelchat Expert 14/10/2018 - 03:24
Here's the new file.
[Uploaded an Excel file]
Excelchat Expert 14/10/2018 - 03:24
That contains the explanation and break down.
User 14/10/2018 - 03:24
Thank You!
Excelchat Expert 14/10/2018 - 03:25
Would there be anything else I can assist you with regards to the original question and the solution provided?
User 14/10/2018 - 03:25
No thank you
Excelchat Expert 14/10/2018 - 03:25
If that's all, I'd like to wish you have a very nice day ahead of you and we'd love to hear from you again. I'd really appreciate if you leave a rating and comment at the end of this session. Thank you for using Got it Pro-Excel!
Excelchat Expert 14/10/2018 - 03:25
Feel free to end the session from your end by pressing the button. Warm regards!

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc