Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
invoices
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
invoices
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 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. -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=523183 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
invoices
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 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. -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=523183 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
track unpaid invoices | Excel Worksheet Functions | |||
How to sum total automatically in more than one sales invoices | Excel Worksheet Functions | |||
Need help determining # of invoices | Excel Discussion (Misc queries) | |||
Pivot Tables - "simple" question | Excel Discussion (Misc queries) | |||
Invoices | Setting up and Configuration of Excel |