enter image description here

I'm trying to write an if else statement in Google Sheets.
I want the value in cell B2 to dictate what the value you will be in cell D2. If the cell B2 is less than 12 than I want D2 = 17, if B2 is less than 15 but greater than 12 then I want it to equal to 16 and so on and so forth as shown by the code above.

  • Any additional feedback for the answers already given?
    – Rubén
    Jan 10, 2020 at 3:02

2 Answers 2


Do I have to use AND?

The formula to use would be:

enter image description here


The function you are looking could be IF or IFS.

The syntax is for IF is


The syntax for IFS is

IFS(condition1, value1, [condition2, value2, …])


  • IFS worked. =IFS(B2<12, 17, 12<B2<15, 16, 15<B2<19, 15, 19<B2<22, 14, 22<B2, 13) . Thank you
    – the_wac
    Dec 10, 2019 at 15:41
  • @the_wac Thanks for confirming. Please accept the answer. Ref. What should I do when someone answers my question?
    – Rubén
    Dec 10, 2019 at 15:43
  • actually 12<B2<15, 16, 15<B2<19, 15, 19<B2<22, 14, none of those statements work. Its apparently not the proper format. Do I have to use AND?
    – the_wac
    Dec 10, 2019 at 16:01
  • I'm sorry, it's not clear to me what you mean. Please create a new question including some sample input data, the expected results, the formula that you tried and the result that you got.
    – Rubén
    Dec 10, 2019 at 16:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.