how to make decimals work?

Sebastian Avila

Hi i´m having a #UNPEARSABLE error everytime y tried to use decimals in my formula, for example:

=IF([KPI ASIGNACIÓN DE OBRA]4 > 3; ([KPI ASIGNACIÓN DE OBRA]4 - 3) * 0.01)

how can i multply with decimals?

Thanks

Mary_A

Try using a comma instead of a semi-colon ;

=IF([KPI ASIGNACIÓN DE OBRA]4 > 3, ([KPI ASIGNACIÓN DE OBRA]4 - 3) * 0.01)

Sebastian Avila

Unfortunately the syntax is differemt depending on wich language you are using smartsheet so in spanish yo have to use semi colon instead of commas in order to make formulas work.

John Jonassen

This seems to work for me, which really isn't changing much from (if any) from what you have already had. Are you typing the column names or are you clicking within the cell? If typing, try clicking and see if that works.

=IF([KPI ASIGNACIÓN DE OBRA]@row > 3; ([KPI ASIGNACIÓN DE OBRA]@row - 3) * 0.01)

Sebastian Avila

Thank you for your help. The problem was that my account had Spain as a region instead of Mexico and somehow that mess up the use of decimals.