One more thing I forgot--I saved the file to Excel 97-2003 thus the xls
extension
instead of the xlxs. I actually am working in Excel 2007. I know there are
some differences but I have been told by several people that if you don't
have 2007 you wouldn't be able to read the file. I can save it in the 2007
and upload it again. I see that the link works in my previous message so
things will be clearer. Thanks, jeel

"jeel" wrote:

I tried the formula. It works for row 4. I would like to drag it down 3 more
rows so I don't have to manually adjust the c4, k4 to c5, k5. Also if I try
to move in new info I got a lot ref errors. Thanks, I hope you are able to
look at the file so we can clear up the confusion. jeel

"David Biddulph" wrote:

I should, of course, have said:
=IF(INDIRECT("C4")<1,0,$K$4-INDIRECT("C4"))

I'd said earlier that the SUM is unnecessary in this case.

If he wants unnecessary functions we could, of course, throw in a few more
and use
=IF(INDIRECT("C4")<1,0,SUM(MIN(AVERAGE(MEDIAN(PROD UCT(MAX($K$4-INDIRECT("C4"))))))))
:-)
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Ah, yes. I understand what you're saying, Gord, but am equally confused
as to why the OP is doing it that way.

If he wants the formula to say unchanged in that situation, then perhaps:
=IF(INDIRECT("C4")<1,0,SUM($K$4-INDIRECT("C4")))
--
David Biddulph

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
David

Jeel is not dragging the D4 formula down column D. He is cutting and
pasting
A4:C4 down to A11:C11

This will definitely change the formula in D4 as described.

My question to Jeel is........if you cut the data from A4:C4 why have a
formula
in D4 referencing those cells?

You have left something out that I can't put my finger on.


Gord Dibben MS Excel MVP

On Wed, 30 Jan 2008 15:24:19 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

With =IF($C$4<1,0,SUM($K$4-$C$4)) in D4 if I drag it down to D11, or copy
to
D11, it remains unchanged, so I don't know how you've got it to change to
=IF($C$11<1,0,SUM($K$4-$C$11)).
If you change the references from absolute to relative by removing the $
signs before the 4, and start with =IF($C4<1,0,SUM($K$4-$C4)), then it
would
change to =IF($C11<1,0,SUM($K$4-$C11)) as you copy it down, butr that
isn't
what you say you've done.

Another question is why you've got the SUM function in that formula?
What
do you think SUM($K$4-$C$4) does for you that $K$4-$C$4 wouldn't? You
may
wish to look in Excel help to remind yourself what SUM does.