formula to change current cell value
 

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

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

formula to change current cell value
 

This would result in 1 (or more, depending on yourformula), but the OP asked
for 0.

Maybe:
=if(yourformula1,yourformula, 0)

Joerg

"Fred Smith" wrote in message
...
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