David Biddulph wrote:
You are trying to nest a number of IF statements, so you need to think about
the placing of the parentheses and of your list separators. Excel help will
tell you about the syntax of an IF statement, and about nesting functions.

=IF(E22=0,0,IF(E22=1,$G$9,IF(E22=2,$G$10,IF(E22=3 ,$G$11,"answer
undefined"))))

Another option is to use VLOOKUP, which again is described in Excel help.
Whether a cell has a number or is the result of a formula is immaterial.
It
[quoted text clipped - 30 lines]

Thanks for your assistance!

This was incredibly helpful. Thank you so much!