| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
set a minimum value for a cell
I have a sheet with two times, and a formula to figure out how much to
charge, depending on the difference between those two times. I would like to set a minimum of 4 hours, such that no matter what two times are entered, if they are less than four hours apart, the result will be 4 hours, but if they are anything more than 4 hours apart, the result will be the actual difference. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
| Seting the minimum value in a cell | Excel Worksheet Functions | |||
| cell minimum value of zero ? | Excel Discussion (Misc queries) | |||
| Maximum and minimum cell value | Excel Discussion (Misc queries) | |||
| How can I set a minimum value of zero or -100% in a cell? | Excel Worksheet Functions | |||
Threaded Mode
