Closed Thread
Results 1 to 2 of 2

Eliminating Errors Resulting from If Functions with Multiple Conditions

  1. #1
    Stephanie
    Guest

    Eliminating Errors Resulting from If Functions with Multiple Conditions

    I would like to know if I can subtract from one colunm to another (Example: =SUM(J20-AB20) and then get the percentage of the sum to show in the same cell. I hope that is not confusing (Example: the sum in the above cell will equal $6,000. I would like to the cell to show 91.14% of the sum)

  2. #2
    Forum Contributor
    Join Date
    12-07-2004
    Posts
    596

    Eliminating Errors Resulting from If Functions with Multiple Conditions

    Problem:

    The following formula returns FALSE, even though both conditions are true (i.e. cell A2=5 and cell B2=8):
    =IF(A2=5&B2=8,TRUE,FALSE)

    Solution:

    Use the IF and AND functions as shown in the following formula:
    =IF(AND(A2=5,B2=8),TRUE,FALSE)

Closed 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