Skip to main content

Can someone formula this? Checkbox with formula

  • January 15, 2018
  • 3 replies
  • 31 views
T

Here is what I want:
I want a formula to multiply the Total Units by 1.95 if OOM? is not checked. And if OOM? is checked, I want Total Units to be multiplied by 2.70.
Let me know if you need anymore info from me. Thanks in advance!!

    3 replies

    T
    • Tyler_Nelson
    • Author
    • Participating Frequently
    • 9 replies
    • January 15, 2018

    I am currently using the following formula, but per the formula formatting section, my function is not fully configured, and I can not change the format to a currency. What do I need to add or take away?

    IF({Tier:}=1, IF({OOM?}=1, {Total Units:}*2.70, IF({OOM?}=0, {Total Units:}*1.95,)))

    T
    Forum|alt.badge.img+19
    • Tuur
    • Inspiring
    • 366 replies
    • January 15, 2018

    I am currently using the following formula, but per the formula formatting section, my function is not fully configured, and I can not change the format to a currency. What do I need to add or take away?

    IF({Tier:}=1, IF({OOM?}=1, {Total Units:}*2.70, IF({OOM?}=0, {Total Units:}*1.95,)))


    Does this work?

    IF({OOM?}=1, {Total Units:}*2.70, {Total Units:}*1.95)

    Formatting works after the formula is accepted.

    A
    Forum|alt.badge.img+18
    • Andre_Zijlstra
    • Inspiring
    • 166 replies
    • January 16, 2018

    Does this work?

    IF({OOM?}=1, {Total Units:}*2.70, {Total Units:}*1.95)

    Formatting works after the formula is accepted.


    Like @Tuur said the Formatting tab/area stays grey until the formula is correct.
    You will see this screen:


    Terms & ConditionsAccessibility statement