value between min and max

[momak]

Hello, I am new in excel programming ... and I need help.
I will simplify problem.
There are 3 cells:
A3 = 100,000
A4 = change every 1 min (connected with other source)
A5 = 50,000

A4 must be between A3 and A5, so I need to have that A4 keeps its ow
value except in situation when it is over then value in A3 or unde
then A5.

Example:
case A4 = 75,000 then 75,000
A4 = 150,000 then 100,000
A4 = 10,000 then 50,000

How to do that

Thanks in advanc

 

[Ron Coderre]

Would it be more practical to have the automated feed go to anothe
cell?

Example:

B4: (automated feed)

A3: 100,000
A4: =MIN(MAX(A5,B4),A3)
A5: 50,000

Something you can work with??

Regards,
Ro

 

[Tom Ogilvy]

easiest would be to have the link in one cell (say B4) and in A5 have a
formula like

=Min(Max(A5,B4),A3)

 

[momak]

My sheet is very complex, with lot of tables, with lot of calculatio
and references between cells. So, I can't make a change lik
dislocating cells because there are a lot of cells in same or differen
sheets which are depending on this one.

Is there any other way

 

[Tom Ogilvy]

Perhaps you could put your link in a defined name. I have never tried it,
so don't know how it would work.

 

[goober]

Here is an example using imbedded "IF" statements.


=IF((SUM(F5:F17)>B11),B11,IF((SUM(F5:F17)<B9),B9,SUM(F5:F17)))

Assuming that (Sum(F5:F17)) is the field you are drawing from this wil
allow your contition and keep you within your perameters.

Hopefully it will help.

Goober