| 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 |
| 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 | |||
Threaded Mode
