| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell result must be a minimum of $1; way to round up to that for amounts between $0-$0.99?
My formula stands as follows:
=IF($A$2<"",CEILING($E$10,0.05),"") it works great but I'm concerned about when the amount of $A$2 causes formula result to fall below $1.00. This cell result refers to an account that has a minimum deposit of $1.00 so if the results are less than that and fall between $0-$0.99, we need to round the result up to the $1.00 minimum. Is there a way to modify the above formula to do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Do I set a minimum(or default) value a a result from formula | Excel Discussion (Misc queries) | |||
| How do I set a minimum result value in an Excel formula? IE 100 | Excel Worksheet Functions | |||
| ROUND CENTS TO EITHER 49 OR 99 AMOUNTS | Excel Worksheet Functions | |||
| How to round up the result in a cell containing formula | Excel Worksheet Functions | |||
| Multiply one cell by a factor and make that result round | Excel Worksheet Functions | |||
![StargateFan[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
