Using symbols in cells and then averaging those cells

Shawn Borror

I have a portfolio level DB and am using health field symbols. I want those health field symbols to equal 1, 2, 3 and then take the average  to provide a program level health. 

I have tried this         

IF([Cell] = "Green", 3, IF([Cell] = "Yellow"), 2, IF([Cell] = "Red"), 1, "")))

But am getting unparseable error.                  

Paul Newcome

Take out the closing parenthesis after "Yellow" and "Red". That should clear up the error and give you your numbers.

Shawn Borror

ah thank you!

Paul Newcome

Happy to help!