1

I have a sheet that I am trying to get an If statement to work. Col B is our hidden stock column and we have three variables that need to be return in COL C:

  1. It has a quantity of 0-9 so the stock shows the exact number in that column
  2. It has a quantity of 10 or more so it shows 10+
  3. It is a product that has moved to a new model year sheet so it needs to return the test in the colum

So if Col B has stock of 8, Col C returns 8. Col B has stock of 11, Col C returns 10+. Col B has See 2023, Col C returns 2023.

Here are my two test formulas: =IF(B2<=9,B2,"10+") =IF(B3="see 2023",B3,B3)

enter image description here

I can not figure out how to combine them.

2 Answers 2

0

A quick and easy way of chaining IF functions is to nest them together.

=IF(B2="see 2023",B2,IF(B2<=9,B2,"10+"))

You can try using an OR function to combine the conditions.

=IF(OR(B2="see 2023", B2 <=9), B2, "10+"))
2
0

This is the answer that was referred to me:

=if(istext(G36),G36,if(isbetween(G36,0,9),G36,if(G36>=10,"10+")))

Your Answer

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

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