Try this in A6:

=IF(A1="","",IF(A1<=1,A3*A1,A4*(A1-1)+A3))

Gives a blank if A1 is blank. Format cell as currency.

Hope this helps.

Pete

On Mar 12, 1:46*pm, AL wrote:
I want to multiply the value in A1 by the $ amount in A3 if the value in A1
is one (1)or less.
If the value in A1 is greater than one (1), then I want to subtract one from
the value in A1 and then multiply the new value in A1 with the amount in A4
and add to this the amount in A3.
* *A3 * * * * * *A4 * * * * *
$10.00 * * *$15.00
* *A1 * * * * * * * * * * * * * * A6
* * 1 * * * * * * *Equals- *$10.00 * * *(1 * $10..00= $10.00)
* *A1 * * * * * * * * * * * * * * A6
* * 2 * * * * * * *Equals- *$25.00 * * *(1 * $15..00 + $10.00= $25.00)
* *A1 * * * * * * * * * * * * * * A6
* * 3 * * * * * * *Equals- * $40.00 * * ( 2 * $15.00 + $10.00= $40.00)
Thanks for any help.