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?

=IF($A$2<>"",MAX(1,CEILING($E$10,0.05)),"")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"StargateFan" <IDon'tAcceptSpam@IDon'tAcceptSpam.com> wrote in message news(E-Mail Removed)...
| 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?
|

Wow, thanks! That seems to work quite well. I did a few tests and so far,
so good.

D

"Niek Otten" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> =IF($A$2<>"",MAX(1,CEILING($E$10,0.05)),"")
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "StargateFan" <IDon'tAcceptSpam@IDon'tAcceptSpam.com> wrote in message
news(E-Mail Removed)...
> | 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?