 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008I'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. in A6: =IF(A1>1,(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. > I want to multiply the value in A1 by the $ amount in A3 if the value in A1 > is one (1)or less. [quoted text clipped - 10 lines] > 3 Equals- $40.00 ( 2 * $15.00 + $10.00= $40.00) > Thanks for any help. 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 > I want to multiply the value in A1 by the $ amount in A3 if the value in A1 > is one (1)or less. [quoted text clipped - 10 lines] > 3 Equals- $40.00 ( 2 * $15.00 + $10.00= $40.00) > Thanks for any help. if(a1<=1,a1*a3,(a1-1)*a4+a3) hth  Signatureregards from Brazil Thanks in advance for your feedback. Marcelo > I want to multiply the value in A1 by the $ amount in A3 if the value in A1 > is one (1)or less. [quoted text clipped - 10 lines] > 3 Equals- $40.00 ( 2 * $15.00 + $10.00= $40.00) > Thanks for any help. =IF(A1<=1,A1*A3,(A1-1)*A4+A3) -- David Biddulph >I want to multiply the value in A1 by the $ amount in A3 if the value in A1 > is one (1)or less. [quoted text clipped - 12 lines] > 3 Equals- $40.00 ( 2 * $15.00 + $10.00= $40.00) > Thanks for any help. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.