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?