Urgent: excel according to the contents of a cell to automatically fill in other cells (…

If a cell when the data for the 80-100, in addition to automatically display a cell outstanding

need to show that the situation in the cell enter:= if (A1> = 80, “excellent”, (if ( A1> = 70, “good”, (if (A1> = 60, “pass”, “Fail “))))) can display more than 80 excellent, well above 70, more than 60 pass, 60 fail the following can be Implementation:When the input values over 100 or below 0 error = if (A1> 100 or A1 = 80, “excellent”, (if (A1> = 70, “Good “, (if (A1> = 60,” pass “,” Fail “))))))) other are similar, constantly nested on the line

hypothetical data in the A1B1 enter = IF (AND (A1> = 80, A1 <= 100), "excellent", "no do not know what the situation you want to fill")

you want to show excellent cell play if (F1> = 80, “excellent”, “pass “) F1 for the data of the cell if you just want to show the elite do not want to pass, the pass but do not delete to delete the quotes.

= if (A1> = 80,” excellent “,””)

= IF (you have to determine the cell> = 80, “Excellent “,””)

cell in the display the results, enter = IF (A1 <60," failed ", IF (A1 <80, "Pass", IF (A1 <90, "excellent", "excellent"))) This will show if the A1 is less than 60 failed, 60 to 80 show a pass, from 80 to 90 showed excellent , 90 more shows Premium!