+ Reply to Thread
Results 1 to 5 of 5

If I apply formula to my column can the cell be blank until data is added?

  1. #1
    Registered User
    Join Date
    03-16-2012
    Location
    PERTH
    MS-Off Ver
    Excel 2007
    Posts
    39

    If I apply formula to my column can the cell be blank until data is added?

    Hi Guys

    I am slowly but surely getting my spreadsheet to do my will.

    I have a spreadsheet where colleagues will copy and paste data from an e-mail which will add data to my formulated columns it works fine however I need to copy my formula to the end of the columns which I have done, this is so my colleagues only need to paste data to make as basic as possible. The problem I have is until the data is copied by my colleagues the formulated cells will show N/a I would really like the sheet to appear blank so as not to confuse my colleagues is there any way to do this.
    This needs to work in 2003 although using 2007

    Thanks you in advance

    Kellis
    Last edited by KELLIS; 08-01-2012 at 11:00 AM. Reason: add info

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: If I apply formula to my column can the cell be blank until data is added?

    hi Kellis, you can try this since you are using 2007:
    =IFERROR(yourformula,"")

    but if you need something 2003 users can apply too, try:
    =IF(ISNA(yourformula),"",yourformula)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    03-16-2012
    Location
    PERTH
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: If I apply formula to my column can the cell be blank until data is added?

    Thanks Benishiryo. I had found the same suggestion for the 2003 user trawling the internet, this works perfectly in one column but not in another maybe you can advise why it will not work in the other column.
    My first column which works was =VLOOKUP(C:C,Sheet3!$A$1:$B$30,2,FALSE) which I changed to
    =IF(ISNA(VLOOKUP(C:C,Sheet3!$A$1:$B$30,2,FALSE)),"", VLOOKUP(C:C,Sheet3!$A$1:$B$30,2,FALSE)) - Perfect
    Yet my other column has the formula
    =VLOOKUP(G:G+0,Sheet3!$D$1:$E$34,2,FALSE) which I have changed to =IF(ISNA(VLOOKUP(G:G+0,Sheet3!$D$1:$E$34,2,FALSE),"",VLOOKUP(G:G+0,Sheet3!$D$1:$E$34,2,FALSE))
    I now get an error saying I have entered too many arguments I thought they should work the same as both Vlookups.
    Any Ideas?

  4. #4
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: If I apply formula to my column can the cell be blank until data is added?

    An extra parenthesis will do the trick..

    =IF(ISNA(VLOOKUP(G:G+0,Sheet3!$D$1:$E$34,2,FALSE)),"",VLOOKUP(G:G+0,Sheet3!$D$1:$E$34,2,FALSE))
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  5. #5
    Registered User
    Join Date
    03-16-2012
    Location
    PERTH
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: If I apply formula to my column can the cell be blank until data is added?

    Thanks I now feel such a muppet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1