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
=if(B3="Washington",0.08,0)
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
b23*e3
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
=e3*f3
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
=e3+g3
User
02/08/2018 - 07:09
=e3+g3
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.
