web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to create multipli...
Power Apps
Answered

How to create multiplication formulas in text cells

(0) ShareShare
ReportReport
Posted on by 46

I have created a simple app that allows entries for new projects. 

 

In a text cell, I want to create a formula that automatically multiplies the values for two other cells. For example, I have length and width input text boxes when filling out a new form, and want a third box for Area below it that automatically multiplies length and width and won't require a separate text entry. I have tried "=" formulas, like in excel, but none seem to work. 

 

If anyone knows how to do this, it would be great. Thanks. 

Categories:
I have the same question (0)
  • Verified answer
    wyotim Profile Picture
    2,545 on at

    Hey @AEngleking, try this out:

    Value(WidthTextInput.Text) * Value(HeightTextInput.Text)

    where WidthTextInput is the name of the text input control for the width and HeightTextInput is the name of the text input control for the height. 


    This is one case where Power Apps and Excel differ greatly. The Value part is to let PA know it is using a number; just having the Text won't always work for everything, even if you set the Format property of the text input to Number (though it will technically work to omit it in this case, it's just a good practice that will save headaches later). Also, you won't need to start any formula with = in Power Apps like in Excel. The equals sign will always be an operator and not a formula designator.

     

    I hope that helps! Feel free to let me know if I can try to help out further or answer any questions!

  • AEngleking Profile Picture
    46 on at

    That worked. Thank you so much!

  • wyotim Profile Picture
    2,545 on at

    @AEngleking Happy to be able to help! 👍🏻

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    I like to use 1* instead of Value(). Saves keystrokes and PowerApps recognizes text as a number. 

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard