Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel percentage formula? (https://www.askmehelpdesk.com/showthread.php?t=523331)

  • Nov 6, 2010, 05:17 AM
    Draycass
    Excel percentage formula?
    I want to know the % of people who have NOT returned to our office after consultation (success rate) For example 51 people had their 1st visit and out of those 51 people only 4 needed to make a second appointment. I want to work out how many people did not return (47) as a percentage using an excel formula. Everything I have tried so far has not worked, Any ideas?

    Many Thanks in advance
  • Nov 6, 2010, 06:21 AM
    jlisenbe

    Why not use this formula? =(C8/C7) where C8 is the cell with 47 in it and C7 is the cell with 51 in it. In "format cell", set the number tab to "percentage". Change the cell values as needed and the percentage will always be current.

  • All times are GMT -7. The time now is 03:51 AM.