View Single Post
  #1   Report Post  
Bay Area DebG
 
Posts: n/a
Default How do I use cell references in calculations?

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?