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? |
#2
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?
=IF($A$2<"",MAX(1,CEILING($E$10,0.05)),"")
-- Kind regards, Niek Otten Microsoft MVP - Excel "StargateFan" wrote in message ... | 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? | |
Reply |
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 |