• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. R

    Calculate a formula to a maximum value

    Brilliant! That seems to work now although using Min seems counter-intuitive. I'm not sure how it works but it seems to. Thanks Excel Ninja.
  2. R

    Calculate a formula to a maximum value

    I need to calculate a formula up to a maximum amount. This is the current formula without having the ceiling I need. =IF(I4=105,105,+I4-I51+I55) The maximum total that this can ever show is 105. This works fine unless the "else" part of the formula(+I4-I51+I55) adds to a number greater than...
Back
Top