+ Reply to Thread
Results 1 to 3 of 3

Help with forumla result when displayed

  1. #1
    Registered User
    Join Date
    06-18-2009
    Location
    Southampton, England
    MS-Off Ver
    xp
    Posts
    4

    Help with forumla result when displayed

    Ok, this must be really simple, I have a worksheet I use at work that calculates volume proccesed hourly, and also shows a running total as you enter hourly figures into the table, my question is can you hide everything in the result cell until the figures for each hour are entered ? currently all the result cells have irrelevant numbers in them until you enter the hours figure and the formulas do there thing, I could relly do with them being blank until the relevant hours information is input?

    Any help appreciated

    Steve
    Last edited by TheCod; 06-18-2009 at 02:48 PM. Reason: resolved

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Help with forumla result when displayed

    surround your current formula with An IF() function...

    e.g.

    =IF(X1="","",your_formula)

    where X1 is the cell to look at.. if it is blank, then the cell the formula is in will stay blank, until something is entered in X1...
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    06-18-2009
    Location
    Southampton, England
    MS-Off Ver
    xp
    Posts
    4

    Re: Help with forumla result when displayed

    thank you, that works a treat.

    Steve

+ 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