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.
