Results 1 to 3 of 3

Nested If statements using both AND & OR

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2011
    Location
    Albany NY
    MS-Off Ver
    Excel 2007
    Posts
    1

    Nested If statements using both AND & OR

    [SOLVED] THANK YOU I created the following statement: =IF(AND(K2>0), IF(OR(M2>0, S2>0, Y2>0,Q2>0, W2>0), ((P2+V2+AB2)/(K2 + Q2 + W2),0)) and I'm not getting the results I expect. I wanted to write a formula that, in human speak says: If K2 is greater than 0 and either M2, S2, Y2Q2 or W2 are greater than 0, than perform (P2+V2+AB2)/(K2 + Q2 + W2), else write 0 in the cell. Can someone tell from my formula what I did wrong? Thank you.
    Last edited by CustomerService; 10-05-2011 at 02:02 PM. Reason: solved

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