It's not exactly the right forum, this. If you look at the header above it on http://forums.cnet.com/?tag=bc you'll this is a forum about developing software for the web. A few lines higher you'll find the Office and Productivity forum, and that's were most Excel questions are coming.
And it isn't really called scripting also. Scripting for a software engineer is a rather specific term, and formulas and even macros in Excel are not called scripting. For macros everything beyond recording is called 'programming' and writing formulas is just, well, called writing formulas.
And your problem is just a formula, and rather easy one also. Choose the one you like most from:
=MAX (0,value)
and
=IF (value>0,value,0)
and
=IF (value>=0,value,0)
I tested these on Excel XP. But I don't think there will be problems in Excel 2007 with them.
For future questions on Excel, please choose the Office forum.
Kees
I am writing an excel sheet to help me keep track of printer toner needs around the office. I am using Excel 2007. For each type of toner we have, i list how many printers we have using it and how many toners we have on hand. The value of the printers using the toner is subtracted from the on hand value and reflected in a cell using this formula: =IMSUB(D4,D5) Where D4 is the number of printers using the toner and D5 is the number of toners on hand. The problem is, that when the number of toners on hand is larger than the number of printers using it, the value ends up being a negative number. I am looking for an IF then else argument to use that would display a 0 instead of any negative number. so instead of the sheet saying that i need to order negative 1 toners, it would say that i need to order 0 :o) .
I have tried many different things, nothing works.
ANY help would be greatly appreciated! Thank YOU!
-Adam S.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic