 |
 | 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 2006invoices
does you know how to create a formula that will select one of two formulas that deduct a percentage 10 or 15 depending on whether a value in another cell is greater than 3 but less than 6, or greater than or equal to 6. it is for part of an invoice/daily records worksheet. hi! may be like this! A2: =IF(AND(A1>=3,A1<6),A1-(A1*10%),IF(A1>=6,A1-(A1*15%),"")) assuming your number is in A1 -VIA135 toll Wrote: > does you know how to create a formula that will select one of tw > formulas [quoted text clipped - 3 lines] > it is > for part of an invoice/daily records worksheet hi! may be like this! B1: =IF(AND(A1>=3,A1<6),A1-(A1*10%),IF(A1>=6,A1-(A1*15%),"")) assuming your number is in A1 -VIA135 toll Wrote: > does you know how to create a formula that will select one of tw > formulas [quoted text clipped - 3 lines] > it is > for part of an invoice/daily records worksheet |
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
|
©2009 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.