Notifications
Announcements
I have problems writing a formula in power automate/excel. I am using the element "write to excel worksheet". I am able to write simple formulas, but this one give me trouble
=IF(G2="test1";0,18;IF(G2="test2";0,20;0)), I need your help, thank you
Hi @Mosgaarden
Your formula is wrong.
IF(G2="test1";0,18;IF(G2="test2";0,20;0))
the format of writing IF condition is IF(condition, value if true, value if false)
Could you explain what you need to acheive by writing the formula ?
Try swapping the semicolon ; for a comma ,
PAD actions defaults to using the american formatting and may crash if you try to use local formatting.
An alternative is to use the "send keys" action and send it as if it were keystrokes instead of an action, then you can use your local formatting
Best Regards,
Thomas Fonn
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 522 Super User 2025 Season 2
Tomac 364 Moderator
abm abm 243 Most Valuable Professional
