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!
Bookmarks