+ Reply to Thread
Results 1 to 3 of 3

subtraction formula, and do not wish to show result until all values are input

  1. #1
    Registered User
    Join Date
    06-03-2012
    Location
    mi, usa
    MS-Off Ver
    Excel 2007
    Posts
    1

    subtraction formula, and do not wish to show result until all values are input

    Hello Everyone, i am new to spreadsheets and i am having trouble trying to figure out how to have a formula of =SUM(c7-c6) put in E7. But the value that needs to be input into C7 will not be known until tomorrow so the result showing in E7 is a negative number. Is it possible to have the result in E7 not show until all values are input that are in the formula? Meaning I do have a value of 8486 in C6 and nothing yet in C7 so the result in E7 is -8486 and i do not want it to show anything until there is a number input in C7.

    This is a chart that tells me how much gas is used in the a day. Column C will be filled in daily and it is the reading of the meter. The reason this is important is because at the bottom of column C there needs to be a total used and when the -8486 is seen by the formula =SUM(E5:E36) in cell E39 it is way off.

    Any ideas would be wonderful!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: subtraction formula, and do not wish to show result until all values are input

    E7: =if(and(c6<>"",c7<>""), c7-c6,"")
    Note that the "" indicates Empty
    Last edited by protonLeah; 06-03-2012 at 01:43 AM.
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Valrico, FL USA
    MS-Off Ver
    Excel 2016
    Posts
    358

    Re: subtraction formula, and do not wish to show result until all values are input

    Alternate formula in E7:

    Please Login or Register  to view this content.

+ 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