Results 1 to 4 of 4

Solver If Function workaround

Threaded View

  1. 07-23-2019, 10:03 AM #1
    Aryo
    Aryo is offline
    Registered User
    Join Date
    07-17-2019
    Location
    Rotterdam, Netherlands
    MS-Off Ver
    365
    Posts
    2

    Solver If Function workaround

    Hi!

    I want to use piecewise linearization on quadratic equation on my linear programming. I have Wij as a decision variable and would like to incorporated it to 1/(Wij)^2 as a dependent variable. I know I can use a certain range to make the quadratic equation linear, but I am not sure on how to do that in Excel.


    I attached my work below, the specified problem located in sheet "correct".

    Thank you in advance!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Solver Constraint If statement workaround
    By tdanner1993 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-19-2023, 01:43 AM
  2. [SOLVED] MATCH function workaround/documentation
    By johnnymac in forum Excel General
    Replies: 3
    Last Post: 02-01-2017, 02:33 PM
  3. MATCH() function help and/or workaround
    By johnnymac in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-31-2017, 08:13 PM
  4. Goal Seek, Solver, and an IRR Workaround
    By Jakila2 in forum Excel General
    Replies: 7
    Last Post: 08-21-2013, 03:48 PM
  5. [SOLVED] Workaround for Excel's VBA Rnd function
    By lunch_bracketeer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2013, 11:11 AM
  6. [SOLVED] MATCH function workaround - nesting ADDRESS function?
    By BishBosh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2013, 03:45 AM
  7. [SOLVED] Is there a workaround for no IFERROR function in 2003?
    By mrvp in forum Excel General
    Replies: 7
    Last Post: 07-22-2012, 11:46 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1