What is wrong with my formula guys?

if (
{revenus ou dépense}=‘revenu’, LEFT({catégorie}, 5), {revenus ou dépense}
)

i want my key field to display different things according to what is written in another field

thanks girls and guys in advance

Perhaps it’s the space between if and the first parenthesis? Make sure you have it formatted properly, like this:

IF(
   {revenus ou dépense}=‘revenu’,
   LEFT({catégorie}, 5),
   {revenus ou dépense}
)
1 Like

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