# Formulas: logical function AND/OR not working as expected

**URL:** <https://community.baserow.io/t/formulas-logical-function-and-or-not-working-as-expected/2436>\
**Category:** Feedback\
**Tags:** formula\
**Created:** [March 12, 2023, 12:23pm UTC](https://community.baserow.io/t/formulas-logical-function-and-or-not-working-as-expected/2436 "2023-03-12T12:23:06Z")\
**Posts on this page:** 4\
**Page:** 2

<div class="post-metadata">

**Author:** ![Mary-Lou](https://community.baserow.io/letter_avatar_proxy/v4/letter/m/4bbf92/32.png) [@Mary-Lou](https://community.baserow.io/u/Mary-Lou)\
**Post date:** [July 3, 2024, 2:47pm UTC](https://community.baserow.io/t/formulas-logical-function-and-or-not-working-as-expected/2436/21 "2024-07-03T14:47:07Z")

</div>

I find it absolutely frustrating to add formulas to baserow.  
The formula editing window is too small, there is no syntax highlighting: [Make formula editor more comfortable to use (larger window, syntax highlighting) (#2778) · Issues · Baserow / baserow · GitLab](https://gitlab.com/baserow/baserow/-/issues/2778)

---

<div class="post-metadata">

**Author:** ![davide](https://community.baserow.io/user_avatar/community.baserow.io/davide/32/2425_2.png) [@davide](https://community.baserow.io/u/davide)\
**Post date:** [July 3, 2024, 3:11pm UTC](https://community.baserow.io/t/formulas-logical-function-and-or-not-working-as-expected/2436/22 "2024-07-03T15:11:02Z")

</div>

> [@Mary-Lou](#):
>
> `and(field('Messaging Language') = "German", field('Gender') = "m"))`

What about something like:

```auto
if(not(isblank(field('Prefix'))) && not(field('Messaging Language') = 'German') && (field('Gender') = 'm'), etc. ,

```

> I find it absolutely frustrating to add formulas to baserow.

I’m sorry to hear that, but I completely understand your frustration. I agree that writing complex formulas can be tricky with our current editor.

Thanks for your feedback and for creating the ticket. I’ll share it with the team to see if we can prioritize it.

---

<div class="post-metadata">

**Author:** ![Mary-Lou](https://community.baserow.io/letter_avatar_proxy/v4/letter/m/4bbf92/32.png) [@Mary-Lou](https://community.baserow.io/u/Mary-Lou)\
**Post date:** [July 3, 2024, 3:32pm UTC](https://community.baserow.io/t/formulas-logical-function-and-or-not-working-as-expected/2436/23 "2024-07-03T15:32:54Z")

</div>

Hi @davide,  
Thanks a lot! I could swear I tried your version before, but now it’s working. So I can keep building the formula.

It would be absolutely amazing to have at least a larger editing window. Syntax highlighting would be brilliant. Thanks again!

---

<div class="post-metadata">

**Author:** ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)\
**Post date:** [August 8, 2024, 9:38am UTC](https://community.baserow.io/t/formulas-logical-function-and-or-not-working-as-expected/2436/25 "2024-08-08T09:38:23Z")

</div>

Hey @Mary-Lou, we see many benefits in introducing the improved editing window for the formula field type, so it’s coming.

The same goes for syntax highlighting, but this will be a lower priority since it requires a lot of development work because we use our own formula language.

[Previous page](https://community.baserow.io/t/formulas-logical-function-and-or-not-working-as-expected/2436.md?page=1)
