Forum Discussion

AndrewLe's avatar
AndrewLe
Qrew Trainee
6 years ago

Using Less/Greater Than operators for numbers within a range?

Hello all, I am currently trying to organize some numerical data with formula operations, however I am having an issue Quickbase taking my code: if([Units Inspected]=0,0,1<=[Units Inspected]<=4,...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Quick Base will evaluate an IF in the sequence listed, stopping either when it runs out of tests or when it finds the first true one.  So it's all about the sequence.  It also helps your own sanity to write the formula vertically. 

IF(
[Units Inspected]=0,0,
[Units Inspected]<=4,1,
[Units Inspected]/4.5)

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