Results 1 to 3 of 3

Thread: Formulas, working out multiple figure

  1. #1

    Formulas, working out multiple figure



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi guys

    I was hoping someone can help me work out this formula, Ill break it down as simple as i can:

    If i have apples and sell singular at 1.50 each
    Then if i sell 72 apples, each apple is 0.99
    If i sell 73 its 72@ 0.99 and 1@1.50

    But after 72 each multiple of 12 is @0.99 (eg 72,84,96)

    If you need more info let me know

    Hope someone can help?

    Cheers guys

  2. #2
    I'm a tad confused, give some worked examples.

  3. #3
    I think I have figured out what you mean, and find the fact that you sell 72 for more than you sell 72 a tad disconcerting.

    Anyway, a bit inelegant, but

    =A2*1.5-INT(A2/72)*72*(1.5-0.99)-NOT(MOD((A2-72),12))*(A2-72)*(1.5-0.99)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •