COPYING SUM/IF FORMULA
- From: Misty <Misty@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 19 Aug 2008 18:32:01 -0700
I am using excel 2007. Creating a inventory spread*** to show initial
quantity and then a continous running total when used. I created a formula to
hide 0 values.
Example =if(sum(c7-e3)=0,"",(sum(c7-e3))).
When I try to copy-my options are copy cell, with formatting or without. It
only copies down the existing answer from the previous cell or I get an error
#value!.
Help!
Thanks
.
- Prev by Date: "IF" function question
- Next by Date: Re: Date changes when copied and pasted
- Previous by thread: "IF" function question
- Next by thread: How do i remove duplicate records in Excel 2007
- Index(es):
