Stars Value

Kenyon Bajus

How can I convert the 1-5 Stars Symbol into a number using one formula. I have one column Stars and the one with number should be Rating.

I also don't know why they chose to have it convert in Excel to Empty, One, Two, Three, Four, Five. Why not numbers?

Thanks for any help.

 

Mike Wilday

This should do it for you...

=If(Stars1="Five", 5, if(stars1="Four", 4, if(stars1="Three", 3, if(Stars1="Two", 2, if(Stars1="One", 1, if(stars1="empty", 0))))))

Kenyon Bajus

@Mike Wilday, yes indeed that did it for me. Thank you very much for the quick reply and working formula!