Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2008
    Location
    philadelphia, Pennsylvania
    Posts
    72
    Thanks
    11
    Thanked 0 Times in 0 Posts

    auto fill cell in Excel

    I use the formula to auto fill a cell: =IF(B1>"","a",0) - but it does not work if the reference cell (B1) is a number - is there a way to auto fill if there is ANY entry in the reference cell? Thanks in advance, excel gurus!

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    This will work:

    =IF(B1<>"","a",0)

  3. The Following User Says Thank You to MartinM For This Useful Post:

    trish12 (2011-06-02)

Posting Permissions

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