Re: First Post: If function
From: Paul B (pnewsbridges_at_uga.edu)
Date: 09/13/04
- Next message: Hans: "Count nr of different records"
- Previous message: Liz G: "First Post: If function"
- In reply to: Liz G: "First Post: If function"
- Next in thread: JE McGimpsey: "Re: First Post: If function"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 13 Sep 2004 11:08:51 -0400
Liz, here is one way,
=IF(ISBLANK(A1),0,1)
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 2003 ** remove news from my email address to reply by email ** "Liz G" <elily00@yahoo.com> wrote in message news:%236%23UMJamEHA.3756@TK2MSFTNGP11.phx.gbl... > Hi, > > This is the first time I am posting to this newsgroup and if it is not the > right place for my question, please point me to the correct newsgroup. > > I am trying to form an 'If' function to say: 'If a cell is not empty, enter > a 1, otherwise enter a 0'. Does anyone know if there is a way to do this? > > Thanks, > Liz > >
- Next message: Hans: "Count nr of different records"
- Previous message: Liz G: "First Post: If function"
- In reply to: Liz G: "First Post: If function"
- Next in thread: JE McGimpsey: "Re: First Post: If function"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|