Here is my problem. I have a list of test results marked out of one hundred.
They have to be reduced to a score out of forty, i.e. seventyfive percent would be thirty.
I would like to be able to just type the percentage into the cell and have it display the score out of fourty.
I tried a few formulas, but it said that it could not do self-references formulas. Is there a way around this?
Additional Details
Hmm, my boss says that so the clients don't get confused, the percentage cannot be shown anywhere on the grid. This means that I can only use ONE box. This is crazy!
2006-07-05
21:34:07
·
7 answers
·
asked by
brendanconnal
1