| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Max Value of a cell
I hit another road block with my formula.
=IF(I19="yes",(((D15/52)*0.6)),0) The max value can only be $1,000. How do I tell it if D15/52*60% is more then $1,000 only enter $1,000. If the value is less then $1,000 then enter the number from the formula. If I19 is no then 0 still needs to be used. Thanks again to everyone! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Threaded Mode
