+ Reply to Thread
Results 1 to 3 of 3

nested formula (if and)

  1. 11-09-2011, 06:04 PM #1
    lpratt
    lpratt is offline
    Registered User
    Join Date
    07-01-2010
    Location
    adelaide
    MS-Off Ver
    Excel 2003
    Posts
    86

    nested formula (if and)

    im sure this is simple but i need

    IF B1 IS TRUE AND F1 = "BAG 1" THEN CELL F3 SHOULD EQUAL E2

    could someone please help.
    Reply With QuoteRegister To Reply
  2. 11-09-2011, 06:09 PM #2
    davegugg
    davegugg is offline
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: nested formula (if and)

    In cell F3:

    =IF(AND(B1=TRUE,F1="BAG 1"),E2)

    You didn't specify a response for false.
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave
    Reply With QuoteRegister To Reply
  3. 11-09-2011, 06:11 PM #3
    Whizbang
    Whizbang is offline
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: nested formula (if and)

    What happens if B1 is FALSE or F1 does not equal "BAG 1"? In the formula below I assume you do not want anything displayed.

    Enter this formula into F3:
    =If(AND(B1,F1="BAG 1"),E2,"")
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1