Results 1 to 2 of 2

finding the highest result of a calculation with variables

Threaded View

  1. #1
    Registered User
    Join Date
    12-01-2003
    Posts
    21

    finding the highest result of a calculation with variables

    Hi,
    I need some help in vba programing.
    I have 10 variables located in cells a1..a10 that can have value of 0-20 with jumps of 0.1 (0, 0.1,0.2...19.9, 20)
    in cell b1 I have calculated cell that is changing according to the variables.

    I want to find which combination of the 10 variables will get me the highest calculated number in cell b1.

    thanks for the help
    Last edited by kman; 09-11-2013 at 02:35 PM. Reason: changing title

Thread Information

Users Browsing this Thread

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

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