minimum a fixed figure when it is lower
 

My M/U figure is $ 45.25.

how to minimum my M/U figure to $ 70.00 when everytime i get lower then
$70.00? and i dont want any changes when i get higher figure.

thanks


+-------------------------------------------------------------------+
|Filename: Untitled-1.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3525 |
+-------------------------------------------------------------------+

--
weepel
------------------------------------------------------------------------
weepel's Profile: http://www.excelforum.com/member.php...o&userid=24531
View this thread: http://www.excelforum.com/showthread...hreadid=381264

Try this:
I53: =MIN(K53*I52,70)

Does that do what you want?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=381264

Ron,

theres still no changes with the function u'd gave.

weepel


--
weepel
------------------------------------------------------------------------
weepel's Profile: http://www.excelforum.com/member.php...o&userid=24531
View this thread: http://www.excelforum.com/showthread...hreadid=381264

Try this ...

=MAX(K53*I52,70)

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=381264

yes, thats exactly i want to know.. thanks benjie and ron for the reply.


--
weepel
------------------------------------------------------------------------
weepel's Profile: http://www.excelforum.com/member.php...o&userid=24531
View this thread: http://www.excelforum.com/showthread...hreadid=381264

You are welcome ... glad I can be of help.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=381264