Results 1 to 2 of 2

Thread: IF function

  1. #1
    Join Date
    Jun 2004
    Posts
    20

    Unanswered: IF function

    Hello,

    I would like to create a formula like this

    if value in cell B2 is between 1-5, B2*1
    if value in cell B2 is between 6-10, B2*2 etc

    Explanation: The value in cell B2 would keep changing. However if the value falls between any of my selected ranges, multiply that value with the appropriate number.

    Can anyone help with this?

    Thanks

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. How many are in the "etc"? That will make a difference on how we set this up. Will that range change over time?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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