Hi Guys, I might actually have a working, almost sane system that I can understand and work with. May I beg some help? | Student | Assgn Points | Points Earned | Possible | Achieved | Percentage | |---------+--------------+---------------+----------+----------+------------| | Barney | 40 | 34.8 | 16 | 14 | 87 | | Betty | 40 | | | | | | Fred | 40 | | | | | | Wilma | 40 | | | | | It might be obvious but, say, quizzes are worth 40 points. There are 16 questions on the quiz and Barney got 14 right. If I'm really nice, would somebody concoct a table formula for me? Rounding would be great. I fully expect to wrestle with formulas on my own at some point, but it took me an inordinate amount of time to come up with the table in the first place, so consequently I'm kind of pressed. Have I mentioned how handsome/beautiful you look today? -- signature angry: "grrrrr" :-)

```
On Sun, Sep 06, 2015 at 12:20:05PM -0400, John Kitchin wrote:
> I assume you want to calculate the Points Earned and Percentage columns?
>
> | Student | Assgn Points | Points Earned | Possible | Achieved | Percentage |
> |---------+--------------+---------------+----------+----------+------------|
> | Barney | 40 | 35. | 16 | 14 | 87.5 |
> | Barney | 40 | 35. | 16 | 14 | 87.5 |
> | Betty | 40 | 30. | 16 | 12 | 75. |
> | Fred | 40 | 25. | 16 | 10 | 62.5 |
> | Wilma | 40 | 17.5 | 16 | 7 | 43.75 |
> #+TBLFM: $6 = ($5 / $4) * 100 :: $3 = ($6 / 100) * $2
Yes, sorry, I looked at my email after I sent it and realized I wasn't
clear about that. Thank you very much for the formula. It's going into
production in about five minutes.
--
signature angry: "grrrrr"
:-)
```