jusolson00

I guess I did try the If function, but found it non helpfull, or i wasnt doing it right. I'll try to give ya an example. the entries i'm interested in are my depreciation list for my business assets., I have it set up so that it calculates the values into the future. well on some assets it uses up the depr. and gives me a zero amount, which i want, and i want to stop there, but then it goes to negative numbers. I suppose i could just edit those functions on those assets so they stop at that point, but i was wondering if there was a condition i could apply to all cells for all the assets to prevent them from calculating a zero amount.

If the "if" function will do this... is it easy to do? I cant seem to get it to work. I guess i dont understand the terminology of sorts. also, the cells that i want to go to zero already have formulas assigned to them, can i still use the "if" function?

okay, well i've played around with the "if" function some more, and it seem to tell me something about circular referance?? also, i can get it to add numbers the cell with the if function, because its adding the "if" function to the orginal function of the cell. I hope i'm explaining this right, thanks again.
Thanks for the help.