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

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

0 3 288
3 REPLIES 3

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.

@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.

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.

Top Labels in this Space