+ Reply to Thread
Results 1 to 17 of 17

IF Statement Inquiry

Hybrid View

  1. #1
    Registered User
    Join Date
    03-19-2012
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: IF Statement Inquiry

    Thank you so much! That 1st formula worked. Much appreciated.

  2. #2
    Registered User
    Join Date
    03-19-2012
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: IF Statement Inquiry

    I have noticed using this formula =IF(AND(ABS(B2)<=0.02,ABS(C2)<=0.02,ABS(D2)<=0.02,ABS(E2)<=0.02),1,"ERROR") only works when there is a value in cell B2 which is great but I sometimes do not have a value in B2. I have also used the other suggested formula =IF(OR(ABS(B2)<=0.02,ABS(C2)<=0.02,ABS(D2)<=0.02,ABS(E2)<=0.02),1,"ERROR") and the results always shows up as 1 even if there is a variance greater then + or - 2 cents in cells B2, C2, D2 or E2. I am not sure why this OR Statement is not recognizing to answer "ERROR" when there is a value greater then + or -2 cents.

+ 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