**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.*