Hey! I'm glad I was able to find this forum. It looks pretty active, so I'm sure there are some brainiacs that can help me with this!

I have a cell that performs an if statement -> *=IF(B4="Good",AF7,IF(B4="Better",AG7,IF(B4="Best",AH7,)))

It allows me to use a data validation menu (the Good, better, best) and (hopefully) change many different calculations in my worksheet.

I'm trying to do simple math off that cell that looks at the if statement cell and multiplies it by a different cell. I keep getting a #Value! error. Is this not possible to do with a cell that contains an if statement?

Also, I apologize if this has been discussed already! I can't seem to find it anywhere!