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
Thanks for the response, I’ve changed the image to show the actual formula. It still won’t work??
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.