View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BoniM BoniM is offline
external usenet poster
 
Posts: 353
Default I'am not sure if this is a (=if) problem

in A6:
=IF(A11,(A1-1)*A4+A3,A1*A3)
Note that the value in A1 will not change, but that the formula subtracts 1
from the number in A1 to perform the calculation.

"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.