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

------------------------------