Forum Discussion
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!
Try this formula:
=IF(ISNUMBER(SEARCH("besteld";AB2));1;0)
(There is no need to use SUM or AB2:AB2 here)
3 Replies
Try this formula:
=IF(ISNUMBER(SEARCH("besteld";AB2));1;0)
(There is no need to use SUM or AB2:AB2 here)
- This works! Thanks for helping! Didn't know I don't need to use the SUM, still learning the ropes of excel formulas : )
