Results 1 to 2 of 2

Thread: conditional equation

  1. #1
    Newbie
    Joined
    Feb 2017
    From
    new Jersey
    Posts
    6

    conditional equation

    Hi
    I have the following equation:
    P = n + 0.12P
    Rearrange:
    0.88P = n
    P = n/0.88
    It works great for my needs EXCEPT for when the ultimate value of "0.12P" is less than 1.
    In this case, I need the equation to be:
    P = n + 1

    I will be applying the code to Excel VBA - how can this be done?
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Feb 2015
    From
    Ottawa Ontario
    Posts
    1,907
    Thanks
    352

    Re: conditional equation

    Not clear; I'll guess you mean this:

    .12P = 1
    P = 1/.12 = 25/3

    Not familiar with Excel, but I presume "IF, THEN" commands exist:
    P = n/.88 : IF P<25/3 THEN P = n+1
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 0
    Last Post: Oct 16th 2016, 06:25 PM
  2. Replies: 2
    Last Post: Sep 10th 2011, 01:23 AM
  3. Replies: 0
    Last Post: Jul 22nd 2011, 01:39 AM
  4. E(XY) and Conditional p.d.f
    Posted in the Advanced Statistics Forum
    Replies: 4
    Last Post: Nov 23rd 2010, 08:29 PM
  5. conditional cdf
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: Jan 28th 2010, 05:32 PM

/mathhelpforum @mathhelpforum