| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List vector using upper and lower limits | Excel Discussion (Misc queries) | |||
| Formula to figure credit card payments | Excel Worksheet Functions | |||
| Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
| How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
| Export to fixed width text file | Excel Discussion (Misc queries) | |||
Linear Mode
