Results 1 to 2 of 2

If or/and statement

This is a discussion on If or/and statement within the Excel Questions forums, part of the Question Forums category; I need help with a code so that if the lookup in W returns any value other than zero, it ...

  1. #1
    New Member
    Join Date
    Feb 2010
    Posts
    28

    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

    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

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