- Aug 19, 2009
I have a sheet of grades in columns. The grades are "raw scores" and don't reflect the real grade since the assignment may have only been worth 80 points. So the 72 in that column is actually a 90%. I want to have a menu option that allows an immediate change of all grades to their percent score, and another that changes them back to their raw scores. I can do this by pasting formulas in that take the raw score from another area where they were copied when the menu selection is activated, divide it by the maximum points possible and multiply it by 100, but then I can't add or change any grades without first copying the raw scores back over the formulas ... Is it possible to have formulas "in the background" that allow input into the same cell? I have seen a program that does this. The user can actually put in raw scores and they instantly change to the percent score if that is the selected view. But when a cell is selected, it shows the raw score, and may be changed, until it is not the active cell, where it changes back to the percent. Is that possible with Excel?