Return text based on value from predefined range

i have a question, i understand about =sum
it total all the amount that we type in, but i dont know how to do like this in the picture
question.png

my total point is 81/100, but i dont know how to do the formula.
example
gold - the point is 90.00 to 99.99
silver - 80.00 to 89.99

i want my total amount auto fill in the silver column because the average point is in around silver average point.

how can i set, when the amount that i get it will detect and fill in the correct column

how can i do that

pls help me, thx

Put the following in each cell
for 100
=IF( total cell =100, cell with total , "")
for 90-99.99
=IF( AND( total cell >=90, total cell <100), total cell, "")
for 80 - 89.99
=IF( AND( total cell >=80, total cell <90), total cell, "")
for 70 - 79.99
=IF( AND( total cell >=70, total cell <80), total cell, "")
for 60 - 69.99
=IF( AND( total cell >=60, total cell <70), total cell, "")

Try this,

Formula:

=IF(AND(A1>0,A1<70),"Diploma",IF(AND(A1>=70,A1<80),"Bronze",IF(AND(A1>=80,A1<90),"Silver",IF(A1>=90,"Gold with Distinction",""))))

Please change the forumtitle according to the forumrules to a more appropreate one.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

No need for nw thread but put title according to the rules (your current title is example how it shouldn't be).
Try something:

Return text based on value from predefined range.