SpencerChaffee
3 years agoQrew Member
Field Formula help
Hey there,
I am looking for some help in turning this excel based formula into something quickbase can handle. It is pretty disappointing that Quickbase does not allow AND/OR operators in your syntax. I am essentially looking to have my formula multiply the user's inputted share change and if it falls between -4 and 4, multiply that input by the weight I have assigned in another column. If the user's input falls outside of the -4 and 4 range, I want to multiply their input by the weight but then divide by 2.
I have tried using the CASE formula but for some reason it won't let me use > or = signs. Is there any way around this that I am missing?
Thanks,
Spencer
------------------------------
Spencer Chaffee
------------------------------
I am looking for some help in turning this excel based formula into something quickbase can handle. It is pretty disappointing that Quickbase does not allow AND/OR operators in your syntax. I am essentially looking to have my formula multiply the user's inputted share change and if it falls between -4 and 4, multiply that input by the weight I have assigned in another column. If the user's input falls outside of the -4 and 4 range, I want to multiply their input by the weight but then divide by 2.
I have tried using the CASE formula but for some reason it won't let me use > or = signs. Is there any way around this that I am missing?
Thanks,
Spencer
------------------------------
Spencer Chaffee
------------------------------