View Single Post
  #2   Report Post  
Jezebel
 
Posts: n/a
Default

You can't do this sort of thing in Word. Calculations are limited to very
limited calculations like SUM(ABOVE). If you're really keen, you could
bookmark D16 and use REF fields; but it's probably better to embed an Excel
table.


"Bay Area DebG" Bay Area DebG @discussions.microsoft.com wrote in message
...
I am trying to calculate grades based on values in a table. Here is the
Excel formula:
=IF(D16899,"A",IF(D16799,"B",IF(D16699,"C",IF(D 16599,"D",IF(D16500,"F"))))).

Unfortunately, this formula does not work in Word. Could someone walk me
through how to reference a cell, perform a calculation on it, and then
return
a single letter value?