Excel - IF Function Problem - Expert Solution

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.

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