Question description:
This user has given permission to use the problem statement for this
blog.
In cell G2, insert an IF function that displays Discount with a “Y†or “N†if the Unit Cost is less
than or equal to 100.
Solved by M. S. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
09/12/2017 - 07:22
Hi
User
09/12/2017 - 07:22
Hello
Excelchat Expert
09/12/2017 - 07:22
I just wanted to confirm that you are looking at creating an IF condition based on the unit cost,right?
User
09/12/2017 - 07:23
That is correct
Excelchat Expert
09/12/2017 - 07:23
Please give me a couple of minutes while I answer your question.
User
09/12/2017 - 07:24
No problem, thank you
Excelchat Expert
09/12/2017 - 07:27
I've created the IF Condition
Excelchat Expert
09/12/2017 - 07:27
The condition works as:
Excelchat Expert
09/12/2017 - 07:28
If the number of units is less than or equal to 100, The discount field would be shown as Y
Excelchat Expert
09/12/2017 - 07:28
Else N
Excelchat Expert
09/12/2017 - 07:28
Is that what you are looking for
Excelchat Expert
09/12/2017 - 07:28
Or is the condition the other way round?
User
09/12/2017 - 07:29
So what would go in the logical_test?
Excelchat Expert
09/12/2017 - 07:29
Here my assumption is that the number of units is entered in the cell F2
Excelchat Expert
09/12/2017 - 07:30
So in the logical test, the parameter/value entered would be:
Excelchat Expert
09/12/2017 - 07:30
F2 < = 100
Excelchat Expert
09/12/2017 - 07:30
You can see the formula in the Formula bar
User
09/12/2017 - 07:30
Got it
Excelchat Expert
09/12/2017 - 07:31
Does that solve your question?
User
09/12/2017 - 07:31
Yes
User
09/12/2017 - 07:31
Thank You very much
Excelchat Expert
09/12/2017 - 07:31
Great. Thank you.
Excelchat Expert
09/12/2017 - 07:31
Looking forward to provide you with help very soon :)
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.
