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 own value except in situation when it is over then value in A3 or under 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 advance

[Ron Coderre]

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

Example:

B4: (automated feed)

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

Something you can work with??

Regards,
Ron

[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)

--
Regards,
Tom Ogilvy


"momak" <[email protected]> wrote in
message news:[email protected]...
>
> 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 own
> value except in situation when it is over then value in A3 or under
> 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 advance
>
>
> --
> momak
> ------------------------------------------------------------------------
> momak's Profile:
http://www.excelforum.com/member.php...o&userid=25386
> View this thread: http://www.excelforum.com/showthread...hreadid=395291
>

[momak]

My sheet is very complex, with lot of tables, with lot of calculation and references between cells. So, I can't make a change like dislocating cells because there are a lot of cells in same or different 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.

--
Regards,
Tom Ogilvy


"momak" <[email protected]> wrote in
message news:[email protected]...
>
> My sheet is very complex, with lot of tables, with lot of calculation
> and references between cells. So, I can't make a change like
> dislocating cells because there are a lot of cells in same or different
> sheets which are depending on this one.
>
> Is there any other way?
>
>
> --
> momak
> ------------------------------------------------------------------------
> momak's Profile:
http://www.excelforum.com/member.php...o&userid=25386
> View this thread: http://www.excelforum.com/showthread...hreadid=395291
>

[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 will allow your contition and keep you within your perameters.

Hopefully it will help.

Goober.