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" :-)
