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 synt...
Forum Discussion
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
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
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
------------------------------
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
------------------------------
- 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
------------------------------
