+ Reply to Thread
Results 1 to 4 of 4

Would like cell to remain blank until information is entered into other cells

  1. 10-30-2013, 09:12 AM #1
    nreed2929
    nreed2929 is offline
    Registered User
    Join Date
    10-29-2013
    Location
    Windsor, Ontario
    MS-Off Ver
    excel 2007
    Posts
    18

    Would like cell to remain blank until information is entered into other cells

    I don't know a lot about Excel and have created a simple spread sheet to track budget spending. In the "total" column I have entered the formula =O14-N14+(N14*0.3030769), this formula is in cell P14 and I would like it to remain blank until information is entered in to either O14 or N14, but curently cell P14 has a zero in it. Any suggestions on how I might alter the formula to have it remain blank until information is entered into cell O14 or N14? Thanks very much. I've tried entering "IF" at the beginning of my formula, but it just gave me error messages.
    Reply With QuoteRegister To Reply
  2. 10-30-2013, 09:15 AM #2
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Would like cell to remain blank until information is entered into other cells

    Perhaps like this?

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  3. 10-30-2013, 09:17 AM #3
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,740

    Re: Would like cell to remain blank until information is entered into other cells

    Try it like this:

    =IF(OR(O14<>"",N14<>""),O14-N14+N14*0.3030769,"")

    Another way would be:

    =IF(AND(O14="",N14=""),"",O14-N14+N14*0.3030769)

    Hope this helps.

    Pete

    EDIT: You could, of course, write O14-N14+N14*0.3030769 as O14-N14*(1 - 0.3030769)

    Pete
    Last edited by Pete_UK; 10-30-2013 at 09:20 AM.
    Reply With QuoteRegister To Reply
  4. 10-30-2013, 09:19 AM #4
    benishiryo
    benishiryo is offline
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Would like cell to remain blank until information is entered into other cells

    welcome to the forum, nreed2929. maybe:
    =IF(COUNT(N14:O14),O14-N14+(N14*0.3030769),"")

    you don't need the brackets for the multiplication too, since it will do that equation first
    =IF(COUNT(N14:O14),O14-N14+N14*0.3030769,"")

    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
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2010: Edit formulas so that cells remain blank if no value is in cell E8
    By Kate in Iowa in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-14-2015, 05:17 AM
  2. Remain Blank until all information is gathered
    By gocolonel77 in forum Excel General
    Replies: 4
    Last Post: 02-21-2013, 06:10 AM
  3. [SOLVED] Need a formula which leaves cell blank when no information entered
    By fben015 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2013, 06:00 PM
  4. how do you make a cell remain blank if there are no values in the necessary cells?
    By LadyFinisher in forum Excel General
    Replies: 5
    Last Post: 06-26-2009, 12:42 PM
  5. [SOLVED] How to keep linked cells blank until information is entered?
    By HollyB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2005, 03:24 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1