Skip to main content
Question

Adding One more condition to the formula

  • July 1, 2022
  • 0 replies
  • 27 views
I have a Currency formula(This field is called Amount to Reimburse to Employee) that work perfectly fine now, however I will need to add more condition to this formula! I would like to say if [Category] equals to "Training" "Amount o Reimburse to To employee " should be 0.
I tried different ways but either it does not work or return formula error!

Any help would be really appreciated 

If([Category Requires # of 1-Way Trips Field],
If([Category - Multiplied by Mileage],
([# of 1-Way Trips] * [Category Rate]) * [Resource' Commuter Miles 1-way],
([# of 1-Way Trips] * [Category Rate])
),

[Mileage Cost]+[Cost]
)

------------------------------
Michael Naser
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+20
    • MikeTamoush
    • Registered
    • July 1, 2022
    If formulas in Quickbase do not need to be nested (like in excel). You can simply list all your conditions like

    If(
     Condition A = "this", "Output this text",
     Condition B = "thisotherthing", "Output different text",
    .....
    )

    Do you mean to have nested if's? If not, can you posted each one of your conditions, and the result on different lines like my example?


    ------------------------------
    Mike Tamoush
    ------------------------------
    Terms & ConditionsAccessibility statement