First picture from Google Sheets, my formula....

(Sebastien Senele) #1

First picture from Google Sheets, my formula. The second one, formula from Appsheet. Error! How could iI solve this problem?

(Aleksi Alkio) #2

You could use IF(B3>0,((B3C3)/144),0) or IF(B3>0;((B3C3)/144);0) depending what locale settings you are using on the sheet.

(Sebastien Senele) #3

@Aleksi_Alkio

I use Canada french. Could I use

IF(B3>0,((B3C3)/144),0) or IF(B3>0;((B3C3)/144);0) for my local setting in Google Sheets? Thanks.

(Aleksi Alkio) #4

It doesn’t matter which one you use for the app. When it works with the sheet, it works in the app. Please check that you are using same locale settings in the app and sheet.