# Excel Formula is not working - logical statement

**URL:** <https://community.glideapps.com/t/excel-formula-is-not-working-logical-statement/57177>\
**Category:** Report a Bug\
**Created:** [January 27, 2023, 5:22pm UTC](https://community.glideapps.com/t/excel-formula-is-not-working-logical-statement/57177 "2023-01-27T17:22:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![montuckyMike](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/montuckymike/32/53473_2.png) [@montuckyMike](https://community.glideapps.com/u/montuckyMike)\
**Post date:** [January 27, 2023, 5:22pm UTC](https://community.glideapps.com/t/excel-formula-is-not-working-logical-statement/57177/1 "2023-01-27T17:22:46Z")

</div>

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](https://www.glideapps.com/plugins/hyperformula)  
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

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 27, 2023, 5:25pm UTC](https://community.glideapps.com/t/excel-formula-is-not-working-logical-statement/57177/2 "2023-01-27T17:25:52Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![montuckyMike](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/montuckymike/32/53473_2.png) [@montuckyMike](https://community.glideapps.com/u/montuckyMike)\
**Post date:** [January 27, 2023, 6:18pm UTC](https://community.glideapps.com/t/excel-formula-is-not-working-logical-statement/57177/3 "2023-01-27T18:18:11Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![montuckyMike](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/montuckymike/32/53473_2.png) [@montuckyMike](https://community.glideapps.com/u/montuckyMike)\
**Post date:** [January 27, 2023, 6:57pm UTC](https://community.glideapps.com/t/excel-formula-is-not-working-logical-statement/57177/4 "2023-01-27T18:57:42Z")

</div>

@Jeff_Hager thank you for responding so quickly btw 😀

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 27, 2023, 6:58pm UTC](https://community.glideapps.com/t/excel-formula-is-not-working-logical-statement/57177/5 "2023-01-27T18:58:44Z")

</div>

No problem!