Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculation
Hello,
I hope someone can help me. I am trying to create a forumula for calculating TAXABLE SALE AMOUNT. I will know 2 things. 1. That the sales tax rate is 6.5% 2. The SALES TAX AMOUNT. For instance if the SALES TAX AMOUNT is $13.00 and the Sales Tax Rate is 6.5% the "caluclated TAXABLE SALE AMOUNT " would be $200.00. I hope this is a acceptable question for this forum. Hopefully one of you math geninus can help me out. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculation
sales tax amount divided by sales tax rate:
=13/0.065 Result = 200 -- Biff Microsoft Excel MVP "Zee" wrote in message ... Hello, I hope someone can help me. I am trying to create a forumula for calculating TAXABLE SALE AMOUNT. I will know 2 things. 1. That the sales tax rate is 6.5% 2. The SALES TAX AMOUNT. For instance if the SALES TAX AMOUNT is $13.00 and the Sales Tax Rate is 6.5% the "caluclated TAXABLE SALE AMOUNT " would be $200.00. I hope this is a acceptable question for this forum. Hopefully one of you math geninus can help me out. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculation
Biff,
Perfect! Thanks for you help and quick response. It is very much appreciated. Zee "T. Valko" wrote: sales tax amount divided by sales tax rate: =13/0.065 Result = 200 -- Biff Microsoft Excel MVP "Zee" wrote in message ... Hello, I hope someone can help me. I am trying to create a forumula for calculating TAXABLE SALE AMOUNT. I will know 2 things. 1. That the sales tax rate is 6.5% 2. The SALES TAX AMOUNT. For instance if the SALES TAX AMOUNT is $13.00 and the Sales Tax Rate is 6.5% the "caluclated TAXABLE SALE AMOUNT " would be $200.00. I hope this is a acceptable question for this forum. Hopefully one of you math geninus can help me out. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculation
What are kids being taught these days ??
Pete "Zee" wrote in message ... Biff, Perfect! Thanks for you help and quick response. It is very much appreciated. Zee "T. Valko" wrote: sales tax amount divided by sales tax rate: =13/0.065 Result = 200 -- Biff Microsoft Excel MVP "Zee" wrote in message ... Hello, I hope someone can help me. I am trying to create a forumula for calculating TAXABLE SALE AMOUNT. I will know 2 things. 1. That the sales tax rate is 6.5% 2. The SALES TAX AMOUNT. For instance if the SALES TAX AMOUNT is $13.00 and the Sales Tax Rate is 6.5% the "caluclated TAXABLE SALE AMOUNT " would be $200.00. I hope this is a acceptable question for this forum. Hopefully one of you math geninus can help me out. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculation
Hmmm...
I don't see the OP's reply to my post but I see it quoted in Pete's reply! Anyhow...to the OP... You're welcome! To Pete... What are kids being taught these days ?? I guess it depends on who the teachers are! Math was not one of my favorite subjects! -- Biff Microsoft Excel MVP "Pete_UK" wrote in message ... What are kids being taught these days ?? Pete "Zee" wrote in message ... Biff, Perfect! Thanks for you help and quick response. It is very much appreciated. Zee "T. Valko" wrote: sales tax amount divided by sales tax rate: =13/0.065 Result = 200 -- Biff Microsoft Excel MVP "Zee" wrote in message ... Hello, I hope someone can help me. I am trying to create a forumula for calculating TAXABLE SALE AMOUNT. I will know 2 things. 1. That the sales tax rate is 6.5% 2. The SALES TAX AMOUNT. For instance if the SALES TAX AMOUNT is $13.00 and the Sales Tax Rate is 6.5% the "caluclated TAXABLE SALE AMOUNT " would be $200.00. I hope this is a acceptable question for this forum. Hopefully one of you math geninus can help me out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Calculation | Excel Discussion (Misc queries) | |||
Excel 97 Calculation Help | Excel Discussion (Misc queries) | |||
Excel Calculation | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |