Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2006
    Location
    Philadelphia, PA
    Posts
    30
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Nest IF/And/Or Too complicated?

    I'd like to write a formula that will apply a % to first $25K of a quarterly balance. Once that condition has been met, the remaining balances for the quarter can be ignored. I attempted an If/And formula but that didn't work. And I'm thinking throwing in "OR" will just make a mess.

    Thoughts?
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Have you tried something like this: =28%*MIN(25000,(B11-B7-B6))

  3. The Following User Says Thank You to kweaver For This Useful Post:

    ab2537 (2013-03-08)

  4. #3
    Lounger
    Join Date
    Mar 2006
    Location
    Philadelphia, PA
    Posts
    30
    Thanks
    12
    Thanked 0 Times in 0 Posts
    Ah! Good idea! Thanks!

Posting Permissions

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