web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Determining numbers sign

Power Apps

Answered

Determining numbers sign

(0) Share

Report

Report

Posted on by Albeik

11

Hello dears,

I'm working on acanvas app and at a certain point I need to determine if 3 value has the same sign (positive or negative) or not.

I'm using 3 text boxes for the numbers and a label to get the result.

I used the below formula in the label Text property but it's not working, any ideas?

If(And(Value(txt1.Text) > 0, Value(txt2.Text) > 0,Value(txt3.Text) > 0),"Same sign",
If(And(Value(txt1.Text) < 0, Value(txt2.Text) < 0,Value(txt3.Text) < 0),"same sign","Not same"),"not same")

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Since your numbers are in text boxes, do the negative numbers look like this? .12345

Was this reply helpful? Yes No
Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
@Albeik

The following should work for you.

With({pos1:Value(txt1.Text) >= 0, pos2:Value(txt2.Text) >= 0, pos3:Value(txt3.Text) >= 0 }, If((pos1=true && pos2=true && pos3=true) || (pos1=false && pos2=false && pos3=false), "Same sign", "Different sign" ) )

The issue with your original formula is that the nested if returns the string "same sign" or "not same", which is not an acceptable boolean value that can be processed by the parent if statement.

Was this reply helpful? Yes No

Join the conversation