web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Grading Scale Calculation

Power Apps

Answered

Grading Scale Calculation

(0) Share

Report

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

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
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
Jakegolden 151 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Join the conversation