Excel Formula is not working - logical statement

Report a Bug
1

I am using a fairly simple IF statement in the use Excel Formula column. I have the IF statement working in excel just fine. I even put in columns A1, A2, A3, A4 in excel to match what I set the variables to be in Glide. Still does not work?
Does it matter that my A1, A2, A3, A4 in Glide as Lookups vs data on that Table?

I also put the formula direct from Excel into this page: Glide • Hyperformula column
To see if I could get it to work there as you hard code the A1, A2, A3, A4 in that webpage, however, the answer it gives me is incorrect.
Wondering what limitations the Excel Formula functionality has then? Anyone else having issues?

Again - the IF statement works perfectly in Excel so the formatting of the formula is not the issue. If have tried both =IF in there and IF

Any help would be awesome as this is a deal breaker for me

2

Can you share screenshots of the formula and what the values look like that you are passing into the formula?

3

Figured it out! So the issue I was running into is that the Excel Formula in Glide does not play very nice with super indepth calculations aka lots of (((())))) - all I did was break out the True statement into its own math cell and the False state into its own math cell. Then in the IF formula I simply referenced the True cell or False cell - worked perfectly!

2 Likes
4

@Jeff_Hager thank you for responding so quickly btw :grinning:

1 Like
5

No problem!