Question description:
This user has given permission to use the problem statement for this
blog.
Could you help me by explaining the IF function?
Solved by G. L. in 24 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
08/10/2018 - 04:09
Hello
User
08/10/2018 - 04:09
hello, im behind in school because i have a learning disability, so i dont learn as fast.
Excelchat Expert
08/10/2018 - 04:09
Welcome to Excelchat, I see that your question is about IF formula
User
08/10/2018 - 04:09
yes
Excelchat Expert
08/10/2018 - 04:09
I can help you with that problem.
Excelchat Expert
08/10/2018 - 04:09
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.
User
08/10/2018 - 04:09
ok
Excelchat Expert
08/10/2018 - 04:09
Let me ask you a couple of quick questions to make sure I fully understand your problem.
Excelchat Expert
08/10/2018 - 04:09
You want to understand, how to use IF function?
User
08/10/2018 - 04:10
yes and what the arguments are
Excelchat Expert
08/10/2018 - 04:10
Can you see the preview on right?
User
08/10/2018 - 04:10
the blank worksheet?
Excelchat Expert
08/10/2018 - 04:10
Yes
User
08/10/2018 - 04:10
yes
Excelchat Expert
08/10/2018 - 04:11
Let me explain how IF function works.
Excelchat Expert
08/10/2018 - 04:11
In Excel it has following syntax to follow;
=IF (logical_test, [value_if_true], [value_if_false])
Excelchat Expert
08/10/2018 - 04:11
3 parts to look at
Excelchat Expert
08/10/2018 - 04:11
logical test i.e .what we are testing.
Excelchat Expert
08/10/2018 - 04:12
Suppose, we can to check if value in B2 is greater than 10 then return Yes, otherwise False.
Excelchat Expert
08/10/2018 - 04:13
So logical test will be B2>10
Excelchat Expert
08/10/2018 - 04:13
Are you with me till now?
Excelchat Expert
08/10/2018 - 04:13
logical_test – It is logical comparison or condition that is tested as TRUE or FALSE.
User
08/10/2018 - 04:13
i think so i should have uploaded my work sheet
User
08/10/2018 - 04:13
i thought id be able to understand without it
Excelchat Expert
08/10/2018 - 04:14
Please share your file.
Excelchat Expert
08/10/2018 - 04:14
and I will explain the IF function on your file.
User
08/10/2018 - 04:14
I need to know the the total cost for the package for the first client, including flight cost
[Uploaded an Excel file]
User
08/10/2018 - 04:15
well i need to know how it works as well
Excelchat Expert
08/10/2018 - 04:15
Ok. Please allow me a minute to check the file.
User
08/10/2018 - 04:15
no problems ill take notes
Excelchat Expert
08/10/2018 - 04:15
is this the complete statement of the quert?
Excelchat Expert
08/10/2018 - 04:15
query*
User
08/10/2018 - 04:16
i can give you the full statement
Excelchat Expert
08/10/2018 - 04:16
Please do so.
User
08/10/2018 - 04:16
Insert and If function in cell g7 to calculate the total cost
Excelchat Expert
08/10/2018 - 04:17
If function based on Flight Needed in Column D?
User
08/10/2018 - 04:17
of the package for the first customer. If the customer needs a flight, the total cost would be the package cost plus the flight
User
08/10/2018 - 04:18
sorry i hit send to fast
Excelchat Expert
08/10/2018 - 04:18
there should be more to this query.
User
08/10/2018 - 04:20
Inslet me re type
Excelchat Expert
08/10/2018 - 04:20
What if the customer does not needs a flight.
User
08/10/2018 - 04:21
then it is just the package
Excelchat Expert
08/10/2018 - 04:21
Ok
Excelchat Expert
08/10/2018 - 04:21
Please check this file.
[Uploaded an Excel file]
User
08/10/2018 - 04:21
but it does include the flight otherwise we would use the vlookup wouldnt we?
User
08/10/2018 - 04:22
yes that is the answer
User
08/10/2018 - 04:22
i need to understand how it works
Excelchat Expert
08/10/2018 - 04:22
Sure.
User
08/10/2018 - 04:22
the Function
User
08/10/2018 - 04:23
thank you!
Excelchat Expert
08/10/2018 - 04:23
Give me a sec.
User
08/10/2018 - 04:24
thanks
Excelchat Expert
08/10/2018 - 04:24
=IF(D7="YES",E7+F7,E7)
Excelchat Expert
08/10/2018 - 04:24
this is the formula I have used.
Excelchat Expert
08/10/2018 - 04:24
Remember our sytax
Excelchat Expert
08/10/2018 - 04:25
=IF (logical_test, [value_if_true], [value_if_false])
Excelchat Expert
08/10/2018 - 04:25
Logical test in this formula is D7="YES" . We are asking it to check if D7 is YES that means the client needs a flight.
User
08/10/2018 - 04:26
ohhhhh
Excelchat Expert
08/10/2018 - 04:26
[value_if_true] is E7+F7. This means, if the logical test is true i.e. if D7 = Yes then it will add E7 and F7.
Excelchat Expert
08/10/2018 - 04:26
i.e. package cost and flight cost.
Excelchat Expert
08/10/2018 - 04:28
[value_if_false] is E7. This means if the the logical test is False i.e. If D7 is not equals to YES then it will just show the value of cell E7 i.e. Package Cost only.
Excelchat Expert
08/10/2018 - 04:28
If/Then/Else.
User
08/10/2018 - 04:28
I learn better from reading so this is perfect. i cant concentrate on the lecture for more than 20 minutes at a time
Excelchat Expert
08/10/2018 - 04:28
If logical test is true THEN this Else that.
Excelchat Expert
08/10/2018 - 04:29
https://www.got-it.ai/solutions/excel-chat/excel-tutorial/if/how-to-use-if-function-excel
Excelchat Expert
08/10/2018 - 04:29
Please check this link, this will provide you each step by step explanation of IF function with example.
User
08/10/2018 - 04:29
this site is a god send
Excelchat Expert
08/10/2018 - 04:30
I am glad you liked our website.
Excelchat Expert
08/10/2018 - 04:30
Does this solution solve your problem?
User
08/10/2018 - 04:30
yes.
Excelchat Expert
08/10/2018 - 04:30
Do you have any other questions about this problem and the solution?
User
08/10/2018 - 04:30
another question not relate dto formulas
User
08/10/2018 - 04:30
is their a limit to how many sessions i can have a day?
Excelchat Expert
08/10/2018 - 04:30
You have to purchase a plan for this.
User
08/10/2018 - 04:31
i did!
Excelchat Expert
08/10/2018 - 04:31
https://www.got-it.ai/solutions.html
User
08/10/2018 - 04:31
the unlimited monthly one
Excelchat Expert
08/10/2018 - 04:31
You can have as many session you want.
User
08/10/2018 - 04:31
great!
User
08/10/2018 - 04:31
i need to work work work on my assignments tommorrow
Excelchat Expert
08/10/2018 - 04:31
Thanks for coming to Excelchat. Also, if you are satisfied with my solution, please go ahead and end the session using the button on the top right hand side of this chat window and requesting you to provide good feedback and review so that I can continue my services to others.
User
08/10/2018 - 04:32
absolutely!
Excelchat Expert
08/10/2018 - 04:32
We are always here to assist you.
Excelchat Expert
08/10/2018 - 04:32
Thank you and have a great day ahead.
User
08/10/2018 - 04:32
have a great day. and happy thanksgiving even if you dont celebrate lol
Excelchat Expert
08/10/2018 - 04:32
Thank you and same to you.
User
08/10/2018 - 04:32
its thanksgiving here
User
08/10/2018 - 04:33
goodnight/day
Excelchat Expert
08/10/2018 - 04:33
Great.
Excelchat Expert
08/10/2018 - 04:33
Good day
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.