formula to change current cell value
Max will do what you want:
=max(1,yourformula)
Note: "zero or less or less than 1" is the same as "less than 1".
--
Regards,
Fred
"Robert H" wrote in message
oups.com...
Is it possible make a cell display the value of Zero if the the cell
value is zero or less or less than 1? Even better is it possible to
change the actual value using a formula under the same circumstances?
thanks
Robert
|