Percentage to display full marks

[randallftan]

Hello,

I am trying to formulate a sheet to read percentages and if percentages are met they get a 100.

I.E student 1 - gets 150 points - he gets 100%
I.E student 2 - gets 102 points - he gets 100%
I.e student 3- gets 90 points - he gets 90%

Essentially anything above 100 gets 100% and anything less than 100 gets a percentage vs 100

[FlameRetired]

randallftan welcome to the forum.

Assuming the points are in column B next to each student's name in column A starting at row 2 try this in column C2 and copy down.

=IF(B2>=100,1,B2/100)

Then format for %.

[randallftan]

randallftan welcome to the forum.

Assuming the points are in column B next to each student's name in column A starting at row 2 try this in column C2 and copy down.

=IF(B2>=1,1,B2)

Then format for %.

Thanks for the warm welcome!. looks like the formula works!!
thanks you so much!

[FlameRetired]

You're welcome. Thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[randallftan]

You're welcome. Thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

done! ty sir!