how to enter totals and sub totals from receipts into excel.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mjd23 - 10 Jan 2008 22:34 GMT

iam needing to enter some gas receipt expenses into a colum but i need to
enter the total amount of the receipt then i have to some how subtract the
tax amount from that. anyone know what i need to do to? I have to seperate
the two and have the two seperate coloums sum????Help. iam still learning....

Reply to this Message

Gord Dibben - 11 Jan 2008 00:45 GMT

Column A has the total for each receipt.

Assuming a constant tax rate of 30%..........B1 has the formula

=IF(A1="","",A1*.7)

C1 has the formula

=IF(A1="","",A1*.3)

Copy both cells down using drag/copy on the fill handle.

In D1 enter =SUM(B:B)

In E1 enter =SUM(C:C)

Do not copy those down.

Gord Dibben MS Excel MVP

>iam needing to enter some gas receipt expenses into a colum but i need to
>enter the total amount of the receipt then i have to some how subtract the
>tax amount from that. anyone know what i need to do to? I have to seperate
>the two and have the two seperate coloums sum????Help. iam still learning....

Reply to this Message

MartinW - 11 Jan 2008 01:54 GMT

Wow! 30%! Is that a real world figure Gord?
We have a 10% Goods And Services Tax here
and I think that's pretty steep.

Regards
Martin

> Column A has the total for each receipt.
>
[quoted text clipped - 25 lines]
>>the two and have the two seperate coloums sum????Help. iam still
>>learning....

Reply to this Message