Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
i have a table in microsoft word as given below

name english hindi odia telugu total average grade
aa 5 5 78 34 122 30.5 ?

how can i find the grade according to following conditions using "if" only

If total mark > 250 the grade “A” else if total mark > 200 grade “B” else if total mark >150 grade is “C” else “F”

What I have tried:

i put the following formula

=if(f2>=250,"a",if(f2>=200,"b",if(f2>=150,"c","f")))

but it is showing

!syntax error, "

it is possible in excel and you can copy to word after performing calculation.
but how it is done in word table?
Posted
Updated 3-Feb-19 11:16am
v2
Comments
OriginalGriff 2-Feb-19 1:33am    
DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalization if you want to be taken seriously.

1 solution

 
Share this answer
 
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900