Question description:
This user has given permission to use the problem statement for this
blog.
I cannot get my IF function work how I would like.
Eg:
I need
IF B4>=243480 then Cell E4 will be D4*0.2 if not then E4 will be D4*0.25
Solved by X. W. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
18/06/2018 - 11:30
Hello, I understand that you need help with an IF() formula that checks the value of B and returns a value depending on it, right?
User
18/06/2018 - 11:30
That's right
Excelchat Expert
18/06/2018 - 11:30
Alright, I can definitely help you with this. Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question. We also currently do not support VBA/Macro solutions.
User
18/06/2018 - 11:30
Thats great thank you
Excelchat Expert
18/06/2018 - 11:31
Here's the formula for E4.
Excelchat Expert
18/06/2018 - 11:31
=if(B4>=243480,D4*0.2,D4*0.25)
Excelchat Expert
18/06/2018 - 11:31
If you can see the document to the right, I have placed it there as well so you can change the value of B4 or D4 and E4 will follow.
User
18/06/2018 - 11:32
Yeah, I have been trying this and It just didn't work for me, I'm pretty certain I wrote it out just like that and for whatever reason it wasn't working but having copied yours it has worked perfectly!
User
18/06/2018 - 11:32
Thank you so much
Excelchat Expert
18/06/2018 - 11:33
Sometimes you just need a second set of eyes to see the tiny details. :) I've been on your shoes plenty of times haha.
Excelchat Expert
18/06/2018 - 11:33
Anyway, glad to have helped!
Excelchat Expert
18/06/2018 - 11:33
Would there be anything else that I can help you with regards to the original question?
User
18/06/2018 - 11:34
Haha, it does help to have another set of eyes. No that is everything, thanks again :)
Excelchat Expert
18/06/2018 - 11:35
Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating and your feedback if you think I deserve it.
Excelchat Expert
18/06/2018 - 11:35
I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of.
Excelchat Expert
18/06/2018 - 11:35
Please do not forget to click the End Session button otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.
User
18/06/2018 - 11:36
Of course, will do. thank you!
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.