Consulting

Results 1 to 3 of 3

Thread: Formula help

  1. 06-06-2007, 07:12 AM #1
    DarrylW
    DarrylW is offline
    VBAX Regular
    Joined
    Sep 2004
    Posts
    26
    Location

    Formula help

    Hi,
    Hope someone can help me. As you can see in the attached row 2 has zeros entered into some of the cells but some are also left blank.

    In the yellow highlighted area I want to put a formula which says if the above cell has a zero return a value of 1 but if the cell in row 2 is blank leave the below cell in the yellow area blank

    Hope I'm making sense.

    Thanks in advance for any help!
    Reply With Quote Reply With Quote
  2. 06-06-2007, 09:43 AM #2
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base     VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    =IF(AND(LEN(B2)=1,B2=0),1,"")
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
  3. 06-06-2007, 09:56 AM #3
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    An alternative

    =IF(AND(B2<>"",B2=0),1,"")
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules