I have a grade book for a school. It is shared online for teachers and staff to use/edit. Due to the number of formulas it can get kind of bogged down. So I am looking to save some processing power and accomplish the same task.
A teacher enters a percent in cell then the cell below has a large formula to calculate the letter grade associated with that percent. So each cell has a big formula for each student and each of their classes.
I am wondering if I switch from: =IF(F1405>=0.93,"A",IF(F1405>=0.9,"A-",IF(F1405>=0.87,"B+",IF(F1405>=0.83,"B",IF(F1405>=0.8,"B-",IF(F1405>=0.77,"C+",IF(F1405>=0.73,"C",IF(F1405>=0.7,"C-",IF(F1405>=0.67,"D+",IF(F1405>=0.63,"D",IF(F1405>=0.6,"D-",IF(F1405="","","N"))))))))))
to: a short lookup() formula with a table that has percent and associated grades. Would that use less memory and run faster?
Thanks
A teacher enters a percent in cell then the cell below has a large formula to calculate the letter grade associated with that percent. So each cell has a big formula for each student and each of their classes.
I am wondering if I switch from: =IF(F1405>=0.93,"A",IF(F1405>=0.9,"A-",IF(F1405>=0.87,"B+",IF(F1405>=0.83,"B",IF(F1405>=0.8,"B-",IF(F1405>=0.77,"C+",IF(F1405>=0.73,"C",IF(F1405>=0.7,"C-",IF(F1405>=0.67,"D+",IF(F1405>=0.63,"D",IF(F1405>=0.6,"D-",IF(F1405="","","N"))))))))))
to: a short lookup() formula with a table that has percent and associated grades. Would that use less memory and run faster?
Thanks