Results 1 to 4 of 4

Goal Seek on multiple cells (HELP)

Threaded View

  1. #1
    Registered User
    Join Date
    05-20-2014
    Posts
    20

    Goal Seek on multiple cells (HELP)

    So, I'm working in a telecom company in Postpaid section, we have recently changed our billing system and now we are facing problem with setting limits to customers.
    for example : a customer requests us to set his monthly limit to 500. while entering the 500 in the limit area, the system allocates the limit in the below format { 500*10%(10% telecom tax) - 400(two months rental) } thus the system will only allow 50 limit per month for the number. [ 500*10%-400 = 50 ].
    my question is ( how to set the exact limit as per customer request i.e. 500 per month instead of 50. I could Achieve this by Goal Seek but it can't be applied to several cells and I have thousands of numbers. attached is an example.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA goal seek multiple cells
    By bjcowen9000 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-10-2014, 06:43 PM
  2. Goal seek on multiple cells
    By oakwood in forum Excel General
    Replies: 1
    Last Post: 06-13-2012, 07:04 AM
  3. How can I use Goal Seek in multiple cells?
    By Rey M in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-22-2005, 11:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1