I want the cell to do a calculation based on the contents of the preceeding
cell. If the preceeding cell contains R, I want it to complete one
calculation, but if the cell contains something different, I want it to
complete a different calculation.

Can anyone provide a suggestion for this?

Thank you.