 SOLVED

# Excel Formula

Hi,

I'm trying to write a formula which checks if a certain cell contains x word. This word is automatically filled in via a Microsoft Power Automate flow. Which adds a row every time the connected Microsoft Form is filled in.

I currently have the following formula =SUM(IF(AB2:AB2="besteld";1;0)). The problem I'm trying to solve is when people fill the form out on their phone they sometimes add a space after the word. As in "besteld ". When this happens my current formula doesn't add a "1" in the used cell.

Does anyone know how to solve this? As in a different formula etc.. Let me know!

3 Replies

# Re: Excel Formula

As variant

``=1*(TRIM(AB2)="besteld")``
best response confirmed by MartVersteeg (New Contributor)
Solution

# Re: Excel Formula

Try this formula:

=IF(ISNUMBER(SEARCH("besteld";AB2));1;0)

(There is no need to use SUM or AB2:AB2 here)

# Re: Excel Formula

This works! Thanks for helping! Didn't know I don't need to use the SUM, still learning the ropes of excel formulas : )