+ Reply to Thread
Results 1 to 2 of 2

How do I set up a range within a IF function?

  1. #1
    RevoProphet
    Guest

    How do I set up a range within a IF function?

    I need to set up a range within an IF function for specific cell reference.
    For example if I have a range from 2.5 to 3.0 I want =IF(A2>=2.5,"B2",0) as
    well as =IF(A2<=3.0,"B2",0) in the same A2 cell. Excel always tell me I have
    too many arguments. It seems simple to get a range. I know it can be done
    with COUNTIF and SUMIF but I don't how with IF. Please help.

  2. #2
    Forum Contributor
    Join Date
    06-10-2004
    Posts
    121
    Try

    =IF(AND(A2>=2.5,A2<=3),B2,0)

+ 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