< > formula

[David Morales]

I am trying to obtain a cell in which the cell value will be limited t
a num greater than 0 but less than 3.
for example cell A has a formula which produces a value in cell B, bu
the value in cell B cannot be negative nor go above 3.
Does anyone have any insight in this are

 

[Harald Staff]

Hi David

1) A formula in A can not produce values in B. Only a formula in B (or a
macro, or typing) can produce values in B.

2) With any number in A1, this in B1:
=MIN(MAX(0,A1),3)
returns a1 value, limited between 0 and 3.

HTH. Best wishes Harald

 

[BenjieLop]

I am trying to obtain a cell in which the cell value will be limited t
a num greater than 0 but less than 3.
for example cell A has a formula which produces a value in cell B, bu
the value in cell B cannot be negative nor go above 3.
Does anyone have any insight in this area

If you need a value to come up in Cell B, the formula must be in Cell
and not in Cell A