Sounds like an inventory program.

--
Regards,
Tom Ogilvy

"Frank Kabel" wrote in message
...
Hi
and what should happen to values like 0.5?

--
Regards
Frank Kabel
Frankfurt, Germany


I have a column of quantities in excel and I want to subtract 1 from
each of these numbers, unless the number is already zero. Any idea
how
to do that?

Thanks!


---
Message posted from http://www.ExcelForum.com/