Display value following multiple IF condition

Hi there, i’ve this situation but i cannot able to show the value in yellow cells, following the formula:

IF({Attivato} = “si”, {Fatturato anno in corso} , {Fatturato atteso calc})

So i want to have, if a cell contain “si” → show a value, otherwise if cell contain “no”, show the other value from another cell.

Any suggestion? Thanks

Hey @davideaba welcome to the community! Try using the SWITCH function instead. The syntax would look like this: SWITCH({Attivato},“si”,{Fatturato anno in corso}, {Fatturato atteso calc}).
This should do the trick!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.