|
Excel help
Hi everybody, I'm not sure where to post this, so i thought i'd give this a try. I'm having a frustrating time trying to figure this out and I've come up with nothing, so i hope you guys can help. I've been putting together a small data base for my small business and I have set up a spreadsheet with a bunch of values that coorespond to diffent things. The problem is that I've got formulas set up for most of the cells, and while they work great, there is one drawback., the data is entered for years, and are forcasted into the future, so when my formulas forcast into the future, some return with a negative value. I do not want this. I want to be able to tell Excel that when the cell value reaches zero, to keep it at zero and not give me a negative number. I hope i explained this enough. Thanks for any help.
Justin.
|