Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
May 27, 2022 10:06 AM
I need to create an IF statement that works with the following logic:
If the value of column X is less than the value of column Y, it needs to return the value of column X.
If the value of column X is greater than the value of column Y, the IF statement needs to subtract the value of column Y by the value of column X.
Can someone please help?
Solved! Go to Solution.
May 30, 2022 01:35 PM
Hi @Christyan_Matos!
First, I’ve opened this topic a few times and seeing that a) @Vivid-Squid had answered and b) seen that your response contained a quote block, I erroneously thought the question remaining the same. I’m sure a few others have done the same for the same reason. It helps when people only use the quote function when the text within the quote block remains the exact same as the quoted text. If you supply new text or info, do that outside of a quote block.
IF formulas work like this
IF({Condition},
{condition is true},
{condition is false}
)
Outputs of an IF formula can be text, a field value or an action.
If text you write the text within quotation marks, e.g. 'desired output'
If field value you wrap the desired field name within curly brackets, e.g. {field name}
.
If action you simply type your desired formula, e.g. desired formula
You can nest IF statements, like in your case
IF({is X greater than the value of column Y},
[True] {Y},
[False] IF({is X equal to Y},
[True] {X},
[False] {X}
)
)
[True] and [False] are there for teaching purposes and should not be there in the actual formula.
Using this; in your case the formula then ends up being
IF(X>Y,
Y,
IF(X=Y,
X,
X
)
)
When you understand the basics you can simplify your formula. In case of comparing numbers Airtable allows us to use >=
Greater than or equal to and <=
Less than or equal to, like @Vivid-Squid did in his answer, which allows us to state your formula as
IF({is Y greater than or equal to X},
{X},
{Y}
)
And the done formula.
IF(Y>=X,
X,
Y
)
You can find all kinds of formula functions here in the formula field reference guide.
I hope that made sense and helped you.
May 27, 2022 10:08 AM
Hi @Christyan_Matos
I am happy to help you. One quick question, what do you want to do if X = Y?
May 27, 2022 10:11 AM
Thank you very much for the return, in this case, if it is equal, repeat the value of column X.
May 27, 2022 10:14 AM
Got it, try this.
IF(X<=Y, X, Y-X)
May 27, 2022 10:23 AM
It turned out great, thank you very much.
May 27, 2022 04:49 PM
A question, considering this scenario:
If the value of column X is greater than the value of column Y, an IF statement must return the value of column Y.
If the value of column X is less than the value of column Y, you must return the value of column X.
If X = Y, repeat the value of column X.
Thanks.
May 30, 2022 01:35 PM
Hi @Christyan_Matos!
First, I’ve opened this topic a few times and seeing that a) @Vivid-Squid had answered and b) seen that your response contained a quote block, I erroneously thought the question remaining the same. I’m sure a few others have done the same for the same reason. It helps when people only use the quote function when the text within the quote block remains the exact same as the quoted text. If you supply new text or info, do that outside of a quote block.
IF formulas work like this
IF({Condition},
{condition is true},
{condition is false}
)
Outputs of an IF formula can be text, a field value or an action.
If text you write the text within quotation marks, e.g. 'desired output'
If field value you wrap the desired field name within curly brackets, e.g. {field name}
.
If action you simply type your desired formula, e.g. desired formula
You can nest IF statements, like in your case
IF({is X greater than the value of column Y},
[True] {Y},
[False] IF({is X equal to Y},
[True] {X},
[False] {X}
)
)
[True] and [False] are there for teaching purposes and should not be there in the actual formula.
Using this; in your case the formula then ends up being
IF(X>Y,
Y,
IF(X=Y,
X,
X
)
)
When you understand the basics you can simplify your formula. In case of comparing numbers Airtable allows us to use >=
Greater than or equal to and <=
Less than or equal to, like @Vivid-Squid did in his answer, which allows us to state your formula as
IF({is Y greater than or equal to X},
{X},
{Y}
)
And the done formula.
IF(Y>=X,
X,
Y
)
You can find all kinds of formula functions here in the formula field reference guide.
I hope that made sense and helped you.
May 31, 2022 10:32 AM
Thank you very much, it was very provocative and made me understand once and for all the use of the function.