+ Reply to Thread
Results 1 to 13 of 13

How to create a min max mathematical formula in excel?

  1. #1
    Registered User
    Join Date
    10-03-2022
    Location
    Oakville, Ontario
    MS-Off Ver
    365
    Posts
    38

    Post How to create a min max mathematical formula in excel?

    f(x)=x^3 formula in excel

    Min max formula??
    Ideally with ^1.125 where negative input numbers are increased the larger the number (1^1.125=1, 10^1.125=13.33521432), and the same happens with positive numbers in the other direction.

    The question is how does one write this formula into excel? It has things on either side of the = sign. I'm trying to min/max a number as an output.
    For example
    -5 A1 = -25 B1
    +5 A2 = +25 B2
    -2 A3 = -4 B3
    +2 A4 = +4 B4
    -10 A5 = -100 B5
    +10 A6 = +100 B6

    I've used ^2 here but I'd like control over that. The above math equation is what I found on the web. I know there is a mathamatical way of describing this.
    This is an image of the graph I'm looking for. The X axis is the input number.

    maxmin2.gif


    Thanks

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: How to create a min max mathematical formula in excel?

    Try, in B1, copied down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    with the power in cell C1.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    10-03-2022
    Location
    Oakville, Ontario
    MS-Off Ver
    365
    Posts
    38

    Re: How to create a min max mathematical formula in excel?

    Thanks! It doesn't work with negative numbers though. Unless you use ^3 but that's much too high.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: How to create a min max mathematical formula in excel?

    Or you can use

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: How to create a min max mathematical formula in excel?

    Wouldn't ABS() work?
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  6. #6
    Registered User
    Join Date
    10-03-2022
    Location
    Oakville, Ontario
    MS-Off Ver
    365
    Posts
    38

    Re: How to create a min max mathematical formula in excel?

    I could use =A1^1.5 but nothing with a ^ works with a negative number and I need it to also work with negative numbers.

    Thanks though!

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: How to create a min max mathematical formula in excel?

    Try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: How to create a min max mathematical formula in excel?

    And

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: How to create a min max mathematical formula in excel?

    -5 -6.114222725 1.125
    5 6.114222725
    -2 -2.181015465
    2 2.181015465
    -10 -13.33521432
    10 13.33521432

  10. #10
    Registered User
    Join Date
    10-03-2022
    Location
    Oakville, Ontario
    MS-Off Ver
    365
    Posts
    38

    Re: How to create a min max mathematical formula in excel?

    OH interesting their is a function in excel specifically for matching the sign of a number! Neat. And ABS just makes the number positive.

    Well great! Simple solve.

    Hope nobody needs the proper mathamatical formula for this.

    Thanks all!

  11. #11
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: How to create a min max mathematical formula in excel?

    Negative numbers to fractional powers has always been a challenge. Can we get a clear description of the scenario? Will the powers always be rational (7/8, 4/3, etc.), or are you also going to be using irrational powers (a lot harder)? Most if not all of your examples are for even roots. Even roots of negative numbers will always be imaginary/complex numbers. Are you willing to take these computations into complex space, or are you only interested in real number results?

    A previous post of mine discussing some programming strategies: https://www.excelforum.com/excel-pro...ml#post5576081
    Last edited by MrShorty; 08-21-2023 at 02:10 PM.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  12. #12
    Registered User
    Join Date
    10-03-2022
    Location
    Oakville, Ontario
    MS-Off Ver
    365
    Posts
    38

    Re: How to create a min max mathematical formula in excel?

    The graph I posted indicates what I wanted. Simple controllable equation for real numbers. I was just hoping there was an actual formula for calculating this. IE: f(x)=x^3 (is what I find online) but only works y=x^3 for both negative and positive numbers when cubed. Any less and they become imaginary?. (Irrational?).

    In any case I was looking for a simple single cell equation/formula to take the input numbers and exponentially output them so that the higher the input the WAY higher/lower the output. Which has been achieved thanks to TMS and others.

    I hope nobody in the future needs to know if their is an elegant formula to this problem that uses strictly math.

    Thanks to all!

    SOLVED

  13. #13
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: How to create a min max mathematical formula in excel?

    You're welcome. Thanks for the rep.



    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Express a mathematical formula in Excel
    By Kiwi101 in forum Excel General
    Replies: 1
    Last Post: 07-26-2020, 05:53 PM
  2. Create a formula based on a mathematical sign from another cell
    By buhaj47 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2018, 07:53 AM
  3. Mathematical EXCEL FORMULA
    By RJ1969 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-02-2018, 04:19 PM
  4. mathematical formula to excel function
    By andersei in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-07-2015, 12:49 PM
  5. Excel formula to solve a mathematical issue
    By TRS in forum Excel General
    Replies: 2
    Last Post: 01-05-2011, 07:14 PM
  6. Re: Please help with an excel mathematical formula
    By EduardoDon in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 01:23 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