If and roundup formula together

kmagpuyo

New member
Joined
Mar 30, 2014
Messages
1
Reaction score
0
Points
0
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:

OTPM

New member
Joined
May 19, 2014
Messages
5
Reaction score
0
Points
0
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
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Try

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