- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โFeb 24, 2025 12:50 AM - edited โFeb 24, 2025 12:52 AM
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โฌ
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โFeb 24, 2025 01:24 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โFeb 24, 2025 06:14 AM
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

