# Thread: If and roundup formula together

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

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. 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
•