Forum Discussion
IF formula help!
Hi I wondered if someone could possibly help. This has me stumped. I’ve created a spreadsheet where Power Automate populates a table with answers from a quiz. It’s working well. The issue is as f...
Hi! You are simply missing a ")" at the end of your formulation to close your IF function. IF works well even with [] characters.
- Hi
Thanks for the response, I’ve changed the image to show the actual formula. It still won’t work??Hi, when you try to reference the character (") in a formula, you should use ("") instead. Thefore, the formulation should be:
=IF(A1="[""Plants""]","It worked!")
Change the cell reference and the actual text based on your case. Just remember to use "" whenever there is an " in your base text.
