• 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. S

    Applying multiple validations

    Great! That formula was what I started with initially but I kept applying that to a range.. I guess applying to a single cell at a time worked now :) Thank you and great response time!
  2. S

    Applying multiple validations

    Hi Nunes, I had the same problem when testing the worksheet and was about to post about it when I noticed you and vijay_s_76 discussing it already. I downloaded the sheet with the new solution but I was wondering if there was any other way(if possible, simpler) to do this. I have around 67...
  3. S

    Applying multiple validations

    Thank you! That helped.
  4. S

    Applying multiple validations

    Hi, Am trying to apply a couple of validations to my worksheet. Firstly, I want to make sure that in a specific range of cells(say A1:F1), the sum of the cell values does not exceed 100. I used the data validation tab and specified a custom validation with the formula (=SUM(A1:F1)<=100)...
Back
Top