< > formula

  • Thread starter Thread starter David Morales
  • Start date Start date
D

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
 
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
 
David said:
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
Click to expand...

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