Results 1 to 4 of 4

Combining IF and AND formulas

Threaded View

  1. #1
    Registered User
    Join Date
    09-14-2010
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    6

    Combining IF and AND formulas

    Hello,

    I have three rows of data in a spreedsheet I am stuck on IF formulas. I have three rows of data. I need to combine IF statements that says:

    IF b3=c3,true, false and IF c3=d3, true, false, and IF b3=d3, true, false. Basically, I need to be able to have the numbers in all three rows be the same, so if they are, then it's true. If there is a discrepancy in any of the three rows, false. For example, row B is 99, row C is 99, and row D is 90. Then I need the formula to tell me that the three rows do not match and is false. Can anyone help me please?
    Last edited by NBVC; 09-14-2010 at 08:56 PM.

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