Excel - IF Function Problem - Expert Solution

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

in cell F3, write an IF function that inserts the value 0.08 if the client is located in Washington and the value 0 if the client is located elsewhere.
Solved by T. E. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 02/08/2018 - 06:55
Hi there!
Excelchat Expert 02/08/2018 - 06:55
Would you be able to tell me which cell has the client location in?
User 02/08/2018 - 06:56
I just need to know how do I go about doing this IF formula
User 02/08/2018 - 06:56
the location is in b3
Excelchat Expert 02/08/2018 - 06:57
Perfect. I can code the formula for you and paste it here and you can review it and try it on your sheet.
User 02/08/2018 - 06:57
ok thank you
Excelchat Expert 02/08/2018 - 06:58
Give this a try:
Excelchat Expert 02/08/2018 - 06:58
Excelchat Expert 02/08/2018 - 06:58
Goes into F3
Excelchat Expert 02/08/2018 - 06:58
Basically the logic is stating exactly what you've described... if B3 = Washington, then put 0.08, and if not, put 0!
User 02/08/2018 - 07:01
ok thank you
Excelchat Expert 02/08/2018 - 07:01
Did it work for you?
User 02/08/2018 - 07:01
so now to multiply the discounted amount by the sales tax rate would I just do this
User 02/08/2018 - 07:02
Excelchat Expert 02/08/2018 - 07:03
Well I am not sure what is in cells B23 and E3.. but if it's the tax rate and the discounted amount then yes absolutely!
Excelchat Expert 02/08/2018 - 07:03
I can't see your file :)
Excelchat Expert 02/08/2018 - 07:03
But yeah the * definitely multiplies the cells.
User 02/08/2018 - 07:05
sorry I meant e3 is the discount amount and f3 is the tax rate
Excelchat Expert 02/08/2018 - 07:05
Oh so you'd do e3*f3 then
Excelchat Expert 02/08/2018 - 07:05
User 02/08/2018 - 07:07
ok now I need to type a formula that uses a mathematical operator to calculate the amount due. and add discounted amount to taxes.
User 02/08/2018 - 07:07
amount due is h3
User 02/08/2018 - 07:07
discounted amount is e3
User 02/08/2018 - 07:08
taxes is g3
User 02/08/2018 - 07:09
so in cell h3 since it goes there would it just be =e3+g4
Excelchat Expert 02/08/2018 - 07:09
User 02/08/2018 - 07:09
Excelchat Expert 02/08/2018 - 07:09
You got it :)
User 02/08/2018 - 07:09
lol yea sorry got is mixed up
Excelchat Expert 02/08/2018 - 07:10
It's all good!
Excelchat Expert 02/08/2018 - 07:11
Just a heads up for next time if you ever need more help... we are only supposed to answer one question per session - I only say it just in case next time the person mentions it, you won't be surprised.
Excelchat Expert 02/08/2018 - 07:11
But it seems like you know what you're doing :)
User 02/08/2018 - 07:12
ok thank you so much though I am trying to do this thing for a class and Ive done this about 2 time and I kept getting it wrong I'm glad I found this thing and I hope I did do it write this time
Excelchat Expert 02/08/2018 - 07:13
I'm glad to help! Sounds like it's perfect to me.
Excelchat Expert 02/08/2018 - 07:27
I hope you have a great day and all the very best!
User 02/08/2018 - 07:29
lol I wish I could stay on here longer so I know I'm doing this all right
Excelchat Expert 02/08/2018 - 07:29
You can always open a new session and we will help you out! 24/7

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
The Allstate Corporation
United Parcel Service
Dell Inc