Forum Discussion

MichelleCoslet's avatar
MichelleCoslet
Qrew Assistant Captain
5 years ago

Formula help

I am trying to create a numeric formula. Hope someone can assist If [ORDER QTY] is between 2 and 8, [SAMPLE SIZE] equals "2", If [ORDER QTY] is between 9 and 15, [SAMPLE SIZE] equals "3", If [O...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Unlike Excel, you typically only need one IF.  Quickbase will evaluate the conditions in sequence and stop at the first  one that is true.

This would be a formula for the field [Sample Size]


If(
[ORDER QTY] <= 1, null, 
[ORDER QTY] <= 8,2,
[ORDER QTY] <= 15,3,
etc
[ORDER QTY] <= 1200, 80,
[ORDER QTY] >= 1201, "125")



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------