Question description:
This user has given permission to use the problem statement for this
blog.
I am looking for a formula to do the following... if a1 is equal to 2 and b1 is greater than or equal to 12 then c1 is $250
Solved by M. Q. in 9 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
06/05/2018 - 01:08
hello! how are you?
User
06/05/2018 - 01:09
good thank you, how are you
Excelchat Expert
06/05/2018 - 01:09
I'm good thanks
Excelchat Expert
06/05/2018 - 01:09
I will now propose a formula based on your problem statement above
User
06/05/2018 - 01:09
thank you
Excelchat Expert
06/05/2018 - 01:10
please see document preview in the right as i make the edits
User
06/05/2018 - 01:10
ok
Excelchat Expert
06/05/2018 - 01:11
okay, now I have a few questions
Excelchat Expert
06/05/2018 - 01:12
scenario 1: what if column A is not equal to 2 and column B is greater than or equal to 12?
Excelchat Expert
06/05/2018 - 01:12
scenario 2: what if column A is 2 but column b is less than 12?
Excelchat Expert
06/05/2018 - 01:12
scenario 3: what if column A is not 2 and column B is less than 12?
User
06/05/2018 - 01:13
Answer to Scenario 1 - then Column C would have a value of 0
Excelchat Expert
06/05/2018 - 01:14
thanks, are you able to see the updates in the document preview?
User
06/05/2018 - 01:14
yes I can see it
Excelchat Expert
06/05/2018 - 01:14
could you confirm if this is in line with your expectations?
User
06/05/2018 - 01:15
yes it is
Excelchat Expert
06/05/2018 - 01:15
glad to hear that, do you need further guidance on the IF() formula presented?
User
06/05/2018 - 01:17
no I believe I have it now. I was leaving out parentheses, but I get it now. Thank you
Excelchat Expert
06/05/2018 - 01:17
Cool. If you don't have any more clarifications at this point, you may end the session by hovering over the TIME REMAINING section of this chat window and select END SESSION
Excelchat Expert
06/05/2018 - 01:17
Also, your kind feedback and rating will be highly appreciated! Thanks!
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.