Dismiss Notice

Welcome To CK5!

Registering is free and easy! Hope to see you on the forums soon.

Score a FREE t-shirt and membership sticker when you sign up for a Premium Membership and choose the recurring plan.

3rd grade math help needed, maybe 4th grade

Discussion in 'The Lounge' started by newyorkin, Feb 2, 2006.

  1. newyorkin

    newyorkin 1 ton status

    Joined:
    May 8, 2001
    Posts:
    16,555
    Likes Received:
    157
    Location:
    Los Estados Unitos
    Nah, just kidding. :D :D

    I do have a math question, though.


    I need to figure out a formula for excel. I've had one running quite some time, but I did a little fiddling with it today and noticed under certain conditions, the output is screwed up... So can any calc gurus help me out if you have a minute...?

    I will call them by column letter for simplicity's sake.

    Right now, the formula reads:
    (N*M)+(P*O)-(C*L)=?

    Looks pretty simple, right? Well it's not with all elements involved.

    N, P, and C are unit prices that can vary. M, O, and L are unit quantities (always equal or less than D, not in the formula).

    L should always be the sum of O and M, and eventually equal D (not included in formula).
    Sometimes O and P are ~0~ and M is simply equal to D, making L and M equal.
    Sometimes M is less than D, but the values for O and P are not yet received (which makes thier and L's values ~0~), and a calculation needs to be made. The result is then incorrect.

    I know some of the data is redundant, like D and L, but this is to allow an external script to read the sheet and compare those numbers to determine first, second, or final sale.
     
  2. newyorkin

    newyorkin 1 ton status

    Joined:
    May 8, 2001
    Posts:
    16,555
    Likes Received:
    157
    Location:
    Los Estados Unitos
    Nevermind, got it. Anyone want to try to figure it out anyway? :D :D :doah:
     

Share This Page