Grading Scale Calculation

(0) Share

Report

Posted on by Jakegolden

151

Hello,

I am trying to create a basic grading scale of

90-100 %= A

80-89 %= B

etc

right now my code is

If (

Value(TextInput2.Text) = Blank(), Blank(),
Value(TextInput2.Text) >= 0.9 , "A" ,
Value(TextInput2.Text) <= 0.89 Or Value(TextInput2.Text) >= 0.80 , "B",
Value(TextInput2.Text) <=0.79 Or Value(TextInput2.Text) >= 0.70 , "C",
Value(TextInput2.Text) <=0.69 Or Value(TextInput2.Text) >= 0.60 , "D",
Value(TextInput2.Text) <= 0.59 , "F"
)

But this is invalid and my calculation is stuck on B even when its lower than 0.80, looking for some tips for adjustments.

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

timl 36,415 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Jakegolden

This syntax should hopefully work.

With({input:Value(TextInput2.Text)}, If( IsBlank(input),"", input >= 0.9, "A", input >= 0.8, "B", input >= 0.7, "C", input >= 0.6, "D", "Fail" ) )

There are more details about this technique in my post here.
http://powerappsguide.com/blog/post/formula-how-to-use-the-if-and-switch-functions

Was this reply helpful? Yes No
Jakegolden 151 on at

Like (0)

Report

Hey @timl

thank you for the quick reply. Appears I was lost in the weeds by trying both the <> symbols within my code. But your solution works perfectly, thank you very much.

Was this reply helpful? Yes No