Need Help changing FORMULA

Z

zipper21

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.
 
N

nastech

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..
 
N

nastech

.... 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..
 
Top