JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
I am using the following formula. For the first part with the sum (BOLDED), how do I turn that result into a percentage and still use the &" /"& to show a number after the /
=SUM($N6:$N10)/80&" / "&INDEX(YEARLY!$AS$110:$AS$145,MATCH($B2,YEARLY!$AN$110:$AN$145,0))
Thank You,
James
=SUM($N6:$N10)/80&" / "&INDEX(YEARLY!$AS$110:$AS$145,MATCH($B2,YEARLY!$AN$110:$AN$145,0))
Thank You,
James