I need help with program to buy things with tax and grand total

%3CLINGO-SUB%20id%3D%22lingo-sub-2016267%22%20slang%3D%22en-US%22%3EI%20need%20help%20with%20program%20to%20buy%20things%20with%20tax%20and%20grand%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2016267%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20with%20program%20to%20buy%20things%20with%20tax%20and%20grand%20total%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EXCEL%20STUFF%20TO%20BUY.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F242923i391774D063AA2616%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22EXCEL%20STUFF%20TO%20BUY.jpg%22%20alt%3D%22EXCEL%20STUFF%20TO%20BUY.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20try%20get%20it%20working%20no%20luck%20getting%3C%2FP%3E%3CP%3Eanybody%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2016267%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2016307%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20with%20program%20to%20buy%20things%20with%20tax%20and%20grand%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2016307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F322399%22%20target%3D%22_blank%22%3E%40sf49ers%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20put%20formulas%20into%20the%20cells%20with%20the%20pale%20orange%20backgrounds.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20added%20a%20column%20for%20%22Qty%22--Quantity--because%20there%20surely%20will%20be%20times%20when%20you%20want%20to%20figure%20taxes%20and%20totals%20for%20more%20than%20one%20item.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20tax%20rate%20is%20now%20what's%20called%20a%20%22named%20range%22--you%20can%20look%20that%20up%20in%20Excel%20help.%20It%20means%20that%20in%20the%20formula%20that%20calculates%20tax%2C%20you'll%20see%20the%20%22sub-total%22%20amount%20multiplied%20by%20%22tax%22.%20If%20the%20tax%20rate%20changes%2C%20that%20number%20in%20the%20green%20background%20can%20be%20changed%20but%20the%20formula%20remains%20the%20same.%20This%20is%20especially%20helpful%20if%20you%20copy%20those%20rows%20down%20to%20allow%20for%20multiple%20items%20being%20purchased%2C%20and%20have%20the%20formula%20being%20used%20multiple%20times.%20Just%20change%20the%20green%20number%20and%20the%20results%20will%20be%20applied%20automatically%20in%20every%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20I've%20copied%20the%20formulas%20down%20some%20more%20rows%20so%20you%20can%20add%20more%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20you%20need%20to%20do%20is%20enter%20items%20to%20be%20purchased%2C%20unit%20price%2C%20and%20quantity.%26nbsp%3B%20The%20rest%20is%20done%20for%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I need help with program to buy things with tax and grand totalEXCEL STUFF TO BUY.jpg

 

I am try get it working no luck getting

anybody help

 

Thanks you

1 Reply

@sf49ers 

 

I've put formulas into the cells with the pale orange backgrounds.

 

I also added a column for "Qty"--Quantity--because there surely will be times when you want to figure taxes and totals for more than one item.

 

The tax rate is now what's called a "named range"--you can look that up in Excel help. It means that in the formula that calculates tax, you'll see the "sub-total" amount multiplied by "tax". If the tax rate changes, that number in the green background can be changed but the formula remains the same. This is especially helpful if you copy those rows down to allow for multiple items being purchased, and have the formula being used multiple times. Just change the green number and the results will be applied automatically in every row.

 

And I've copied the formulas down some more rows so you can add more items.

 

All you need to do is enter items to be purchased, unit price, and quantity.  The rest is done for you.