Welcome to the Airtable community!
The formula field reference has info on the functions to combine to do what you want.
IF( {customer billing) = "indirect",
{indirect total sales revenue},
{indirect total sales revenue} * 1.12,
)
Welcome to the Airtable community!
The formula field reference has info on the functions to combine to do what you want.
IF( {customer billing) = "indirect",
{indirect total sales revenue},
{indirect total sales revenue} * 1.12,
)
thank you very much! it helps.
the first condition of the formula works.
I still need the second condition in the formula
should the formula continue with:
OR IF ( {customer billing = “direct”, {indirect total sales revenue}) ?
Welcome to the Airtable community!
The formula field reference has info on the functions to combine to do what you want.
IF( {customer billing) = "indirect",
{indirect total sales revenue},
{indirect total sales revenue} * 1.12,
)
thank you very much Kuovonne! it helps.
the first condition of the formula works.
I still need the second condition in the formula
should the formula continue with:
OR IF ( {customer billing = “direct”, {indirect total sales revenue}) ?
Thank you again!
thank you very much Kuovonne! it helps.
the first condition of the formula works.
I still need the second condition in the formula
should the formula continue with:
OR IF ( {customer billing = “direct”, {indirect total sales revenue}) ?
Thank you again!
The second situation is handled in the last part of the ÌF function, where the {indirect total sales revenue} is multiplied by 1.12. Since the {customer billing} field can only have two values, the function only needs to test if the {customer billing} is “indirect”. If {customer billing} is not “indirect”, then it must be “direct”, without having to explicitly test for it.
On the other hand, if you really want a different formula that explicitly lists all of the possible values for the {customer billing} field, you can use a switch function.
SWITCH({customer billing},
"indirect", {indirect total sales revenue},
"direct", {indirect total sales revenue} * 1.12
)
There are many different ways of doing things with formulas/code. Pick whatever makes the most sense to you.
If neither of these formulas work for you, please send a screen capture annotated with your desired results!
The second situation is handled in the last part of the ÌF function, where the {indirect total sales revenue} is multiplied by 1.12. Since the {customer billing} field can only have two values, the function only needs to test if the {customer billing} is “indirect”. If {customer billing} is not “indirect”, then it must be “direct”, without having to explicitly test for it.
On the other hand, if you really want a different formula that explicitly lists all of the possible values for the {customer billing} field, you can use a switch function.
SWITCH({customer billing},
"indirect", {indirect total sales revenue},
"direct", {indirect total sales revenue} * 1.12
)
There are many different ways of doing things with formulas/code. Pick whatever makes the most sense to you.
If neither of these formulas work for you, please send a screen capture annotated with your desired results!
Kuovonne,
You were 100% correct. No need to use the SWITCH instruction (even though I learnt something new!).
My IF formula works exactly as I needed it to.
Thank you again for your help, very instructive.
François
