How to write Grade from given percentage in excel?

Help Forum
, , , , , , , , ,
1

Hi,

In my excel sheet, there is already given student total and percentage.
By using this I have to generate and write Grades (according to given percentage) in excel sheet.

Anyone please help me with solution.

Thanks.

2

can you tell us the grade and corresponding percentage range?

3

Assignment2.xlsx (10.0 KB)

Hi,

Please find attached excel.

4

i mean what percentage is each grade?

e.g. A = 80-100 etc… B = 60-80…

5
Percentage Grade
above 90 A
above 60 - 90 B
above 35 - 60 C
below 35 D
6

refer to this
Excel.xaml (17.5 KB)

result

image
image941×271 9.2 KB

2 Likes
8

You could use a State Machine with 4 different transitions based on the grades. Place it inside a ‘for each row’ activity.

Each transition will write in its given row(“Grade”) based on the rule you set

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.