I need a formula that will return a harvey ball. For example
0 would = an empty harvey ball
1 would = a 25% filled harvey ball
2 would = a 50% filled harvey ball
3 would = a 75% filled harvey ball
4 would = a 100% filled harvey ball
I have tried the formula below, but it only returns a number, not a harvey ball, so apparently there is something wrong with my formula.
=IF(J2=$M$5,$N$5,IF(J2=$M$6,$N$6,IF(J2=$M$7,$N$7,IF(J2=$M$8,$N$8,IF(J2=$M$9,$N$9)))))
Help Please.
Last edited by sgonzalez66; 01-18-2018 at 02:57 PM. Reason: Forgot to put my formula
Hello and welcome to the forum.
Assuming that J2 has an integer value of 0 through 4, try this:
=CHOOSE(J2+1,"○","◔","◑","◕","●")
If you were looking for something different, you can use a pie chart referring to two cells (one for empty % and one for full %)
Full % =0.25*J2
Empty % =1-0.25*J2
For example, with J2 = 3,
Full % = 0.25*(3) = 0.75 which will be displayed as 75% of the pie chart
Empty % = 1-0.25*(3) = 1-0.75 = 0.25 which will be displayed as 25% of the pie chart
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks