Dancing With The Stars

Michael Drayton

Hey family!

I have a column with the Stars symbol. I'm using it to rank 1 to 5. While its pretty, I can't seem to quantify them. For example 5 stars = 90%, 4 stars = 70%, etc.

this formula doesn't seem to work:
=IFERROR(IF(VALUE(Probability@row ) = 5, 0.9, IF(VALUE(Probability@row ) = 4, 0.7, IF(VALUE(Probability@row ) = 3, 0.5, IF(VALUE(Probability@row ) = 2, 0.25, IF(VALUE(Probability@row ) = 1, 0.1, 0))))), 0)

any help is greatly appreciated.

thanks
Michael

DKazatsky2

Hi @Michael Drayton,

Can you explain more what is happening? Also, the values are not 5,4,3,2,1,0 - they are actually "Five", "Four", "Three", "Two", "One", "Empty". Try checking against those instead.

You also shouldn't need to use VALUE(). Give this a try.

=IFERROR(IF(Probability@row = "Five", 0.9, IF(Probability@row = "Four", 0.7, IF(Probability@row = "Three", 0.5, IF(Probability@row = "Two", 0.25, IF(Probability@row = "One", 0.1, 0))))), 0)

Hope this helps,

Dave