value between min and max
 

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

--
moma
-----------------------------------------------------------------------
momak's Profile: http://www.excelforum.com/member.php...fo&userid=2538
View this thread: http://www.excelforum.com/showthread.php?threadid=39529

value between min and max
 

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

--
Ron Coderr
-----------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...fo&userid=2141
View this thread: http://www.excelforum.com/showthread.php?threadid=39529

value between min and max
 

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" wrote in
message ...

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

value between min and max
 

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

--
moma
-----------------------------------------------------------------------
momak's Profile: http://www.excelforum.com/member.php...fo&userid=2538
View this thread: http://www.excelforum.com/showthread.php?threadid=39529

value between min and max
 

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" wrote in
message ...

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

value between min and max
 

Here is an example using imbedded "IF" statements.


=IF((SUM(F5:F17)B11),B11,IF((SUM(F5:F17)<B9),B9,S UM(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

--
goobe
-----------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...fo&userid=1983
View this thread: http://www.excelforum.com/showthread.php?threadid=39529