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€
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.