Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum and minimum cell value
I need help with a formula. I need C22 to return a value of O5 x C21, but the value of C22 should never be higher than the value in Z98 and never lower than the value in Z99. Right now, all I have in C22 is *=O5*C21 *but of course it returns higher than Z98 or lower than Z99 so my spreadsheet won't work. Can anyone help? Thanks in advance! -- sharkfoot ------------------------------------------------------------------------ sharkfoot's Profile: http://www.excelforum.com/member.php...o&userid=32164 View this thread: http://www.excelforum.com/showthread...hreadid=519148 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum and minimum cell value
Hi
What do you want if O5*c21 is less than Z99 or more than Z98? Andy. "sharkfoot" wrote in message ... I need help with a formula. I need C22 to return a value of O5 x C21, but the value of C22 should never be higher than the value in Z98 and never lower than the value in Z99. Right now, all I have in C22 is *=O5*C21 *but of course it returns higher than Z98 or lower than Z99 so my spreadsheet won't work. Can anyone help? Thanks in advance! -- sharkfoot ------------------------------------------------------------------------ sharkfoot's Profile: http://www.excelforum.com/member.php...o&userid=32164 View this thread: http://www.excelforum.com/showthread...hreadid=519148 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum and minimum cell value
In C22 put the formula .MIN(MAX(Z99,05*C21),Z98) ed
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum and minimum cell value
whoops: that should have a = in front of it
=MIN(MAX(Z99,.05*C21),Z28) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivottable formula : maximum one field - minimum of another one | Excel Discussion (Misc queries) | |||
Minimum and Maximum with Complex Criteria | Excel Discussion (Misc queries) | |||
formula that includes a maximum amount | Excel Worksheet Functions | |||
Allow any Certain chr within a cell | Excel Discussion (Misc queries) | |||
Need to find a row in a worksheet based on the value of a cell | Excel Worksheet Functions |