Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: If or/and statement

  1. #1
    New Member
    Join Date
    Feb 2010
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default If or/and statement

    I need help with a code so that if the lookup in W returns any value other than zero, it leaves X blank. If the lookup in W returns 0 then X=0

    *WX
    1Tight Net Tight Net Rolls
    23.255
    32.253
    400
    500

    Spreadsheet Formulas
    CellFormula
    W2=IF(VLOOKUP(C2,Table1,20,FALSE),VLOOKUP(C2,Table1,20,FALSE),0)
    W3=IF(VLOOKUP(C3,Table1,20,FALSE),VLOOKUP(C3,Table1,20,FALSE),0)
    W4=IF(VLOOKUP(C4,Table1,20,FALSE),VLOOKUP(C4,Table1,20,FALSE),0)
    X4=IF(Table2[[#This Row],[Tight Net ]]=0,0,ISBLANK)
    W5=IF(VLOOKUP(C5,Table1,20,FALSE),VLOOKUP(C5,Table1,20,FALSE),0)


    Excel tables to the web >> Excel Jeanie HTML 4

  2. #2
    Board Regular SamTYler's Avatar
    Join Date
    Mar 2004
    Location
    Columbia, Missouri, USA
    Posts
    784
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If or/and statement

    =IF(VLOOKUP(C2,Table1,20,FALSE)<>0,"",0)
    SamT
    XP+SP3, Office 2003+P2
    Recently of Niland, Ca.
    Now in Columbia, Mo. USA
    No Work, No money, No home

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com