Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'am not sure if this is a (=if) problem
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'am not sure if this is a (=if) problem
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'am not sure if this is a (=if) problem
if(a1<=1,a1*a3,(a1-1)*a4+a3)
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "AL" escreveu: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'am not sure if this is a (=if) problem
=IF(A1<=1,A1*A3,(A1-1)*A4+A3)
-- David Biddulph "AL" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |