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.