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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 229 Super User 2026 Season 2
11manish 223 Super User 2026 Season 2
Valantis 136 Super User 2026 Season 2
