Help

The Community will be temporarily unavailable starting on Friday February 28. Weโ€™ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF function help

96 2
cancel
Showing results for 
Search instead for 
Did you mean: 
amusic
4 - Data Explorer
4 - Data Explorer

I have a collumn where i need to calculate price for a product, it already works it calculates the cell with amount of products  times the price. 
Now I would need to add, if possible, that this function only calculates price if in the other collumn "troลกak nositelj" its NOT set (narudลพbenica or kupac plaฤ‡a), and to calculate price  ONLY IF the field is set to "budลพet" or if its empty.  If troลกak nositelj is "narudลพbenica", or "kupac plaฤ‡a" the price should stay 0โ‚ฌ

amusic_1-1740386803781.png 

amusic_2-1740387003963.png

 

 

2 Replies 2
Milan_Automable
6 - Interface Innovator
6 - Interface Innovator

I suggest using the "Generate Formula" feature with Airtable AI, for requests like this I find it relatively reliable.

โ€” Best, Milan - Automable.AI Free Airtable consultation

Mike_AutomaticN
10 - Mercury
10 - Mercury

Hey @amusic!

Given the language, I might be missing smth. However please give the following formula a shot -or at least use it to understand the structure which should be used:

IF(
    OR(
        {Troลกak nositelj} = "budลพet",
        {Troลกak nositelj} = BLANK()
    ),
    {KOL QR} * 1.45,
    0
)




Three interesting components to the formula you might want to take home:
IF() formula for building different conditional branches on your formula
OR() formula for one of the conditions being if X or Y occurs.
Blank() for the "is not set" part of your formula. -this is were you might need some changes. Blank means that the field is empty (or not filled with anything). However, if you specifically want it to be that it is not narudลพbenica or kupac plaฤ‡a, then you might need to use AND({Troลกak nositelj}!="narudลพbenica", Troลกak nositelj}!="kupac plaฤ‡a").

Let me know how I can further help!

Mike, Consultant @ Automatic Nation