+ Reply to Thread
Results 1 to 3 of 3

formulas

  1. #1
    las
    Guest

    formulas

    how do I use a % range for instance if f13 is 25-75% in a formula

  2. #2
    Bob Phillips
    Guest

    Re: formulas

    =IF(AND(F13>=25%,F13<=75%),"yes","no")

    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    "las" <las@discussions.microsoft.com> wrote in message
    news:F912E1EA-9AC9-40A9-9DF5-1F18D93C4694@microsoft.com...
    > how do I use a % range for instance if f13 is 25-75% in a formula




  3. #3
    las
    Guest

    Re: formulas

    Bob

    I have been working on this for hours...thank you for you assistance it
    worked!

    las

    "Bob Phillips" wrote:

    > =IF(AND(F13>=25%,F13<=75%),"yes","no")
    >
    > --
    > HTH
    >
    > Bob Phillips
    >
    > (remove nothere from email address if mailing direct)
    >
    > "las" <las@discussions.microsoft.com> wrote in message
    > news:F912E1EA-9AC9-40A9-9DF5-1F18D93C4694@microsoft.com...
    > > how do I use a % range for instance if f13 is 25-75% in a formula

    >
    >
    >


+ 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