Results 1 to 3 of 3

Thread: If and roundup formula together

  1. #1

    If and roundup formula together



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I need help. I am trying to create a calculated field but I am having a hard time. I am working in a call center and I am currently working on the scores of my agents.

    Scoring
    Not Resolved/ Number of Survey
    Target = 19%

    =IF(TARGET<=0.19,0,ROUNDUP(??????????


    What i would like to do is I want to get the specific number of Surveys for me to reach the target score.


    I am someone can help me out me here.


    You may reach me on my skype: kuro.chan2x

    Thanks,

    Kristian
    Last edited by kmagpuyo; 2014-03-30 at 06:36 AM.

  2. #2
    Hi Kristian
    Do we take it that your formula is "Not Resolved" divided by "Number of Survey" and then divide that figure by 19%? If so why do you want to use ROUNDUP?
    Also is it possible to paste a sample spreadsheet so I can take a look.
    Tony

  3. #3
    Try

    =IF(NumResolved/NumSurvey<=19%,ROUNDUP(NumSurvey*19%,0),"")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •