Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function for tax?
Let's say I get a hotel for two nights at the same hotel.
One night costs $50 and the second night $55. The total bill is $105. The tax is 12.75. Is there a function in Excel that can tell me a) what the tax is per night b) how it's distributed. I tried using solver but it just cut the tax in half. Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function for tax?
Hi
With night1 in A1 and night2 in A2, Total tax in B1, enter in C1 =ROUND($B$1/SUM($A$1:A2)*A1,2) and copy down -- Regards Roger Govier "TB in DC" wrote in message ... Let's say I get a hotel for two nights at the same hotel. One night costs $50 and the second night $55. The total bill is $105. The tax is 12.75. Is there a function in Excel that can tell me a) what the tax is per night b) how it's distributed. I tried using solver but it just cut the tax in half. Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function for tax?
Thank you.
That is another way to look at. Have a great day! "Roger Govier" wrote: Hi With night1 in A1 and night2 in A2, Total tax in B1, enter in C1 =ROUND($B$1/SUM($A$1:A2)*A1,2) and copy down -- Regards Roger Govier "TB in DC" wrote in message ... Let's say I get a hotel for two nights at the same hotel. One night costs $50 and the second night $55. The total bill is $105. The tax is 12.75. Is there a function in Excel that can tell me a) what the tax is per night b) how it's distributed. I tried using solver but it just cut the tax in half. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |