Hi,
I am fairly new to power apps and have just recently been presented with a solution as to why power apps wasn't recognising my basic mathematical formulas (with ".Value"! Thank you!). From this I think there are other nuances I have not been able to pick up on through reading or videos and was wanting to ask for some help.
I am now trying to incorporate "If" statements using >= and <=.
The formula is meant to associate a value ("3" or "1") with a number equal to or greater than "10" in this case, and reads as follows.
"If(Cell2.Value >= "10", "3", "1")" which does not work.
The formula "If(Cell2.Value = "10", "3", "1")" works fine, but adding a < or > to it on either side of the "=" shows an error.
My thinking is that Power Apps stops recognising "10" as a number, but I'm not sure why it would do this or if my guess is completely off base. After testing I have found that using < or > is something power apps doesn't like at all despite my reading FAQ's and watching videos to the contrary.
The end goal is to embed multiple "If" statements to associate a large quantity of numbers with a specific value ranging from 0 - 3. As an example, this formula works in excel perfectly:
"=IFS(C2>=131,3, C2<=40,3, C2<=50,1, C2>=111,2, C2>=91,1, C2>=51,0)"
and i should be able to recreate it in power apps using just "If" instead of IFS and "Cell2.Value" instead of "C2".
I have attached a PDF with my formulas in the app and the results in power apps which I hope will help show better than I might be explaining.
Thank you for any help or advice you can give,
