Excel - IF Function Problem - Expert Solution

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.

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.