+ Reply to Thread
Results 1 to 3 of 3

logic operations

  1. #1
    Registered User
    Join Date
    03-23-2005
    Posts
    21

    Angry logic operations

    when using a logic function how do you combined multiple logic operations?
    ex. if b13=3 and f13=480 true=3 false= b13=2 and f13=480 true=2 false=
    and so on would it look something like this:

    =if(and(b13=3,and(f13=480), "3", if

    and just repeat???
    Thanks for all the help.

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451
    The first part of your formula would be:

    =IF(AND(B13=3,F13=480),3,"insert here what you want if either B13 doesn't equal 3 or F13 doesn't equal 480")

    Note there are no quotes around the 3. If you want the 3 to be text as opposed to the number leave your quotes in.

  3. #3
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474
    I guess, something like this...

    =IF(AND(B13=3,F13=480),3,IF(AND(B13=2,F13=480),2,IF(AND(B13=1,F13=480),1,"")))

    Hope this helps!

+ 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