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

    How to find values in a range and assign differtn numbers to them?

    Thank you- how can I moify the formula to look for ranges, ie between .25 and .49 for a value then .50 and .74, etc. Can I also add negative values in the formula ie lookign for between -.25 and -.50?
  2. M

    How to find values in a range and assign differtn numbers to them?

    What fomula will tell me if the values in column B(DIFF) fall into one of these categoires, Between 0.00 and 0.25 is .25, Between 0.251 and 0.50 is .50. Between 0.51 and 0.75 is .75. Greater than 0.751 is 1.00 ST Diff Indiana 0.50 Ohio 1.05 Ohio 1.00 Ohio 0.25 Thank you
Back
Top