+ Reply to Thread
Results 1 to 2 of 2

Figuring a formula based on a cell value range

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    Mesa, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    1

    Smile Figuring a formula based on a cell value range

    I am trying to add a cell function the corresponds with another cell's range of value. So, how can I create this: "If this cell's value is between this value and this value, then execute this formula, or if the same cell's value is between a different value, then execute this formula." Does that make sense. Thanks for the input.

  2. #2
    Registered User
    Join Date
    04-24-2006
    Posts
    12

    Re: Figuring a formula based on a cell value range

    if(and(a1>b10,a1<b10),do this,do a different formula)

    Quoting: If this cell's value (a1)is between this value and this value (b10)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1