# Getting Started

View Only

## Field Formula help

• #### 1.  Field Formula help

Posted 04-20-2022 09:59
Edited by Spencer Chaffee 04-20-2022 09:59
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
------------------------------

• #### 2.  RE: Field Formula help

Posted 04-20-2022 10:01
Quickbase does easily handle and and ors.  Lately it wants then in lower case.  I can't read your screen shot but if you copy and paste your formula as text as an update to this thread, then I can assist.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

• #### 3.  RE: Field Formula help

Posted 04-20-2022 10:06
Sorry about that. It looked bigger when I pasted.
Here is the formula:

IF(and([fy22 mkt share chg vs ya]>=-4,[fy22 mkt share change vs ya]<=4), [fy22 mkt share chg vs ya]*[weight],([fy22 mkt share chg vs ya]*[weight]/2))

------------------------------
Spencer Chaffee
------------------------------

• #### 4.  RE: Field Formula help

Posted 04-20-2022 10:40
try this

IF(
[fy22 mkt share chg vs ya]>=-4 and [fy22 mkt share change vs ya]<=4,
[fy22 mkt share chg vs ya]*[weight],
[fy22 mkt share chg vs ya]*[weight]/2)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------