Answered

How to add or subtract between two labels

(0) Share

Report

Posted on by Sahara22

568

Hello , if I have two text labels that have numbers how do I add or subtract them and put the answer in a third label ? For instance . If label1 and less then label two then I’d need to subtract. If label 1 is greater then label 2 then ill need to add.

Ex: label 1 (10) — label 2 (15) label 3 should say (-5)

or label 1 says (15) and label 2 says (10) label 3 should say (+5)

Any help would be great!! 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

In label3 use the formula: Value(Label1) - Value(Label2)

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Sahara22,

Do you want to do calculation based on the number size?

Actually, I think @Jeff_Thorpe provides a correct formula that directly calculate the difference between label and label2, which skip to check the number size of both.

If you insist on write a condition to check the number size firstly, you should try the following formula that you could set it for the Text property of the Label3:

If( Value(Label1.Text) > Value(Label2.Text), "+" & Abs(Value(Label1.Text) - Value(Label2.Text)), "-" & Abs(Value(Label1.Text) - Value(Label2.Text)) )

Was this reply helpful? Yes No
Sahara22 568 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-qiaqi-msft @Jeff_Thorpe thank you!

Was this reply helpful? Yes No