Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 69
  • Last Modified:

Excel: formula to determine # to meet goal

Hi Experts,

I have a requirement to provide the amount tickets need to reach a goal (85%).  To get a better understanding I am doing this in excel but will end up being converted to Tableau's custom formula.  I would expect to see a result of 5 as it should be rounded to a whole number.  Any idea how I would go about writing this?

Here are the data inputs:

Vendor	Closed	Total tickets	Current %	Target %	Tickets need to hit Target
Joe's shop	22	31	70.97%	85.00%	?

Open in new window

See attached

Thanks
Tickets-needed.xlsx
0
Maliki Hassani
Asked:
Maliki Hassani
  • 2
  • 2
1 Solution
 
Patrick MatthewsCommented:
Assuming you mean, "how many existing tickets do I need to close to hit my target", try this:

=MAX(0,ROUNDUP(C2*E2,0)-B2)
1
 
Patrick MatthewsCommented:
Note that what I provide above is an Excel formula. I presume Tableau has similar functions that would allow you to do this
0
 
Maliki HassaniAuthor Commented:
Great... That works now let me see if I can code it in Tableau.
0
 
Maliki HassaniAuthor Commented:
Thanks
0
 
Mike in ITIT System AdministratorCommented:
You will need to use a formula like this:

=ROUNDUP((E2*C2)-B2,0)

Open in new window


I have attached a modified version of your spreadsheet.

For the example that you have in the spreadsheet the ROUND() number would actually be 4 since the result is 4.35. By using ROUNDUP() it will always round up to the next int.
Tickets-needed.xlsx
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now