User Name Remember Me? Password

 Algebra Pre-Algebra and Basic Algebra Math Forum

 October 8th, 2014, 06:20 PM #1 Member   Joined: Oct 2014 From: Mars Posts: 37 Thanks: 0 Simplify this formula (MIN/MAX) Hi all, I hope this is the right math section to post this, I'm having trouble simplifying this formula. $\displaystyle MIN(1,(MIN(1,MIN(x,y)+MAX(0,x-0.9))*MIN(y*100,1))+0.0000001)$ x and y is a percent value from 0% to 100% (0-1). My brain cannot handle this I would really appreciate it if someone could help me. Thanks in advance for your help Last edited by Apple30; October 8th, 2014 at 06:23 PM. October 9th, 2014, 10:59 PM #2 Member   Joined: Oct 2014 From: Mars Posts: 37 Thanks: 0 Never mind, please delete this thread. October 9th, 2014, 11:32 PM #3 Senior Member   Joined: Apr 2014 From: UK Posts: 963 Thanks: 342 The problem is it isn't really just a formula, it has decisions in it (min,max). If this is an Excel formula, you can reduce (I think!) the number of MINs If that's the case, then this is as simple as I could manage: 0.0000001+MIN(0.9999999,y*100, (MIN(x,y) + MAX(0,x−0.9)) * MIN(y*100,1)) (I think that's right ) Do you have a description of what result you are trying to achieve, there may be a different solution. October 10th, 2014, 02:48 AM #4 Math Team   Joined: Apr 2010 Posts: 2,780 Thanks: 361 You can use $\displaystyle \min(x, y) = \frac{x + y}{2} - \left|\frac{x - y}{2}\right|$ and $\displaystyle \max(x, y) = \frac{x + y}{2} + \left|\frac{x - y}{2}\right|$ If abs is too much of a decision, you can use $\displaystyle |x| = \sqrt{x^2}$ and the taylorexpansion of $\displaystyle \sqrt{1+u} = \sum_{n=0}^{\infty} \frac{(-1)^n(2n)!}{(1-2n)\cdot (n!)^2\cdot (4^n)}u^n= 1 + \frac{x}{2} - \frac{x^2}{8} + \frac{x^3}{16}- \cdots$ where u = 1-x^2 to get |x| or a good approximation of it. Thanks from weirddave October 13th, 2014, 05:31 AM #5 Senior Member   Joined: Apr 2014 From: UK Posts: 963 Thanks: 342 Abs should be sufficient, not too sure this is going to simplify much further though  Tags formula, min or max, simplify ### max math farmula of algebra

Click on a term to search for related topics.
 Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Similar Threads Thread Thread Starter Forum Replies Last Post markmain Algebra 1 January 5th, 2011 11:28 PM wulfgarpro Algebra 19 April 26th, 2010 12:56 PM agro Probability and Statistics 3 August 27th, 2009 06:17 AM goodgirl Elementary Math 4 November 17th, 2008 04:17 AM Ghoti Algebra 1 July 18th, 2008 11:13 PM

 Contact - Home - Forums - Cryptocurrency Forum - Top      