Rewriting a formula...

  • Thread starter Thread starter Roz
  • Start date Start date
R

Roz

I have a spreadsheet that calculates totals and has formulas in certain
columns. Is is possible to have the formulas work, but not have any
numbers in the cells before I input them? For example, in column D, I
have the simple formula =D9+E9, and so on and so forth down to
=D25+E25. I may only put itmes in until D11. So in D12 thru D25, I
have $0.00. Can I rewrite this formula, possible an IF/THEN statement
to add the two columns, but not show the $0.00 in D12 thru D25, since I
did not have to do any addition? My main goal is to not have this info
in D12 thru D25 print to make the sheet look cleaner. Thanks in
advance.
 
Perhaps one simple way to achieve a cleaner look in the sheet (as it stands)
is to try switching off zeros display via clicking:
Tools > Options > View tab > Uncheck "Zero values" > OK
 

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

@Sum Conditional Values within a Macro 1
ERRORS IN A DIVISON FORMULA 11
help on conditional 2
"Not More Than" in a formula 1
Help in long formula! 2
Count the number of Instances 4
Formula won't calculate 3
Using an IF to combine multiple formulas 5

Back
Top