Forum Discussion

ShannonC2024's avatar
ShannonC2024
Copper Contributor
Apr 25, 2023
Solved

Help with formula for percentage

Hello,  I'm not great at Excel so I am sorry for the elementary question.  In column J, I have the number of open agents.  In column N I have the number of agents at 180 days.  If our goal is to retain 80% of agents by 180 days, how do I find the percent to goal for column O?

 

 

excel
  • NikolinoDE's avatar
    NikolinoDE
    Apr 25, 2023
    To find the percent to goal for column O in Excel, you can use the following formula: =N1/0.8 .
    This formula divides the number of agents at 180 days in column N by 0.8 (which represents the 80% retention goal) to calculate the percent to goal.
    You can then copy this formula down column O to find the percent to goal for each row.

2 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Apr 25, 2023
    To find the percent to goal for column O in Excel, you can use the following formula: =N1/0.8 .
    This formula divides the number of agents at 180 days in column N by 0.8 (which represents the 80% retention goal) to calculate the percent to goal.
    You can then copy this formula down column O to find the percent to goal for each row.

Resources