formula?

[WolfClaw1974]

not sure if i have right place but i'm looking for a way to have in cell a number thats value depending on another cell total eg. if the total of b2 is <9 then i want c2 to show 1 and if b2 is<18 c2 to show 2. the reasoning is 12 is 1 carton and i'm using 75% of 12 as my min range for ordering

 

[ETAF]

=IF(B2<9,1,IF(B2<18,2,""))

not sure what you are doing without seeing a spreadsheet

But that will do what you want - put the formula in C2

if you want it to also be less than 9 or equal to 9 , and same for 18 then
=IF(B2<=9,1,IF(B2<=18,2,""))
NOTE the = sign added