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

+18

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}
)

Sign up