formula to change current cell value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert H - 20 Feb 2007 03:49 GMT

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

Reply to this Message

Fred Smith - 20 Feb 2007 04:28 GMT

Max will do what you want:

=max(1,yourformula)

Note: "zero or less or less than 1" is the same as "less than 1".

Signature

Regards,
Fred

> 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

Reply to this Message

Joerg - 20 Feb 2007 07:39 GMT

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

Maybe:
=if(yourformula>1,yourformula, 0)

Joerg

> Max will do what you want:
>
[quoted text clipped - 8 lines]
> > thanks
> > Robert

Reply to this Message