Forum Discussion

SpencerChaffee's avatar
SpencerChaffee
Qrew Member
3 years ago

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...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
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
------------------------------
  • SpencerChaffee's avatar
    SpencerChaffee
    Qrew Member
    3 years ago
    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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      3 years ago
      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
      ------------------------------