|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 10th, 2008, 01:33 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If calculations
I need to calculate sales tax from two states with different sales taxes. I
want to designate one cell with a T or N and then have my invoice calculate the sales tax pertaning to that state depending on what that cell has in it. How do I build this formula? 
|
|
#2
July 10th, 2008, 01:48 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If calculations
Something like:
=IF(A1="T",6.5%,IF(A1="N",5%,0)) where A1 contains T or N (and I've guessed the tax rates). Hope this helps. Pete "ClassyCleaning" wrote in message ... I need to calculate sales tax from two states with different sales taxes. I want to designate one cell with a T or N and then have my invoice calculate the sales tax pertaning to that state depending on what that cell has in it. How do I build this formula?
|
|
#3
July 10th, 2008, 10:15 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If calculations
That worked. Thanks.
"Pete_UK" wrote: Something like: =IF(A1="T",6.5%,IF(A1="N",5%,0)) where A1 contains T or N (and I've guessed the tax rates). Hope this helps. Pete "ClassyCleaning" wrote in message ... I need to calculate sales tax from two states with different sales taxes. I want to designate one cell with a T or N and then have my invoice calculate the sales tax pertaning to that state depending on what that cell has in it. How do I build this formula?
|
|
#4
July 11th, 2008, 12:23 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If calculations
You're welcome.
Did I guess right? Pete On Jul 10, 10:15*pm, ClassyCleaning wrote: That worked. Thanks. "Pete_UK" wrote: Something like: =IF(A1="T",6.5%,IF(A1="N",5%,0)) where A1 contains T or N (and I've guessed the tax rates). Hope this helps. Pete "ClassyCleaning" wrote in message ... I need to calculate sales tax from two states with different sales taxes. I want to designate one cell with a T or N and then have my invoice calculate the sales tax pertaning to that state depending on what that cell has in it. How do I build this formula?- Hide quoted text - - Show quoted text -
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
