Hiding balance total


G

Guest

I have a monthly expense spreadsheet that I wrote that works off of a
declining balance. It's got about 15 rows but on the months that I don't use
all 15 rows, I don't want the balance showing in the column of the otherwise
blank row. The current (simple) formula looks like this: =J7-E8. Very simple,
but when i don't have an entry for "e8", I don't want the formula cell to
show anything at all. Anyone?
 
Ad

Advertisements

G

Guest

Try using the =if function to control display,

=if(E8="","",J7-E8)

Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top