I am useing this formula =IF(CELL("address")="$D$173",D173+E173,E173)
works good for adding to total .
But can how can I get it to subtract in the some way with no histery of
the amount entered.


--
zipper21
------------------------------------------------------------------------
zipper21's Profile: http://www.excelforum.com/member.php...o&userid=33025
View this thread: http://www.excelforum.com/showthread...hreadid=528913

novice here, but not quite sure what you're asking,.. probably with series of
if's, not's / and-or's...

IF(cell<"",step1,IF(cell="x",otherstep,IF(cell="" ,"",laststep)
what is the address portion refer to
maybe do not want "" quotes around the $D$173..

"zipper21" wrote:


I am useing this formula =IF(CELL("address")="$D$173",D173+E173,E173)
works good for adding to total .
But can how can I get it to subtract in the some way with no histery of
the amount entered.


--
zipper21
------------------------------------------------------------------------
zipper21's Profile: http://www.excelforum.com/member.php...o&userid=33025
View this thread: http://www.excelforum.com/showthread...hreadid=528913

.... notice $D$173 not used on both sides, that on purpose? $ refers to a
fixed (absolute) cell.. if that helps... D173 will change for each new line
copied to.. D174 etc..