Announcements
I'm working on an app that would take a "Reading" value and compare it to a minimum value that is pulled from a Sharepoint list. If the reading value is less than or equal to the minimum value, it returns "Pass" and if the reading value exceeds the minimum value it returns "Fail". I'm having difficulty writing the formula in the Pass / Fail field.
Example:
Reading
-1.00
Minimum
-0.002
Pass / Fail
Pass
Hi @kcornell ,
try this,
If(Value(reading)<=Value(minumum),"Pass","Fail")
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.Regards,KrishnaIf this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
@kcornell
The basic IF statement is written like this...
If(-1.00 <= -0.002, "Pass", "Fail")
If you need help retrieving the value from SharePoint you'll have to share more info about where it is being stored.
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
@mdevaney , right, but the issue I was having while I was trying setting this up was that it kept looking at the value as text and not as a number. Using Value() prior to the number helped with this issue. I tried changing the text format from TextFormat.Text to TextFormat.Value and was still getting an error. I appreciate the assistance!
@KrishnaV
Additional question, if I wanted it to look at a text value, Positive or Negative before it applies this formula, how would I write the new formula? This is because the less-than sign would change to greater-than for positive values.
After trying myself I was able to get the following formula to work for me with the Negative / Positive.
If(Negative/Positive.Text = "Positive",If(Value(Reading.Text)>=Value(Minimum.Text),"Pass","Fail"),If(Value(Reading.Text)<=Value(Minimum.Text),"Pass","Fail"))
Sincere apologies for not able to help you on time, I was completely arrested with my work today!
I am really happy that you were able to make it.
Regards,
Krishna
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.
WarrenBelz 355 Most Valuable Professional
11manish 209 Super User 2026 Season 2
MS.Ragavendar 150 Super User 2026 Season 2
