Getting formulas not to appear on worksheet

A

amiart

I need to have running totals of daily average sales show on .. Howeve
the only way I know how to do this displays a "0" in each of th
cells... How can I have it calculate and display without the "0" o
anything except the results showing up in the "Target" cell???
 
C

CH33CH

For a quick fix, you can go to TOOLS, OPTIONS and then UNSELECT the checkmark under "zero values"
However, for a real solution, do a little research on creating IF/THEN functions, with them you can really control what the cell reads
Take a few examples
=IF(ISNA(VLOOKUP(C9,Bdata,6,FALSE)),"",(VLOOKUP(C9,Bdata,6,FALSE))
This returns a blank if there is no value looked up from the named range "BDATA

=IF(A16>=701,"END OF LIST, Click the DOWN ARROW",IF(A16<=0,"START OF LIST",IF(ISNA(HLOOKUP(A17,AdvName,(A16),FALSE)),"",(HLOOKUP(A17,AdvName,(A16),FALSE))))
You can really get funky with formulas and make them display all sorts of info based on what values are in your shee
 
D

David McRitchie

Who, When, Why, Where, How Much

You got code ?

A running total is like the balance column in your
checkbook. Take a look at
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
It may answer more questions than you thought you had.
Especially when it comes to use of OFFSET.

For averages, what do you want to do for blanks.
Show us what you used. What you got. What you expected.
How are you maintaining the total and the count.

A good question and a good answer helps others as well.
A good guess without much explanation might only help you,
or it could be a bad guess (good answer, wrong question).
 
Top