Create a 5 Star Rating System in Excel
Published October 4, 2017
Views 142K | Likes 748 | Comments 55
At a glance
Views
142,697
Likes
748
Comments
55
Performance vs. channel
Outlier score
Engagement rate
More features coming
We're working on new analytics and tools. Stay tuned.
About
In this video, we create a 5 star rating system in Excel using Conditional Formatting. The formula below is used in the video to calculate what star is needed in each cell. =IF($B2*=I$1,1,IF(INT($B2)=I$1-1,MOD($B2,1),0)) Use the greater than sign in place of the asterisk. The asterisk is used as angle brackets are n…
- Published
- October 4, 2017
- Made for kids
- No
More features coming
We're working on new analytics and tools. Stay tuned.