Buy/sell expenses add less

[Kalpesh123]

Hello

I have some products i want all item list buy sell entry in 1 sheet but when item buy this time 5-6 different expenses and tax add in price and when item selling then 5-6 type tax/expenses less from selling price
then please

any option to set when entry for buy then net amount calculating with all tax and expenses adding and when entry for selling then taxes less from selling price and net price calculate after less all expenses

 

[Joe4]

Your question is not very clear to us. In these cases, it is often helpful to post an example, posting some data along with your expected results. Then often we can see exactly what you are trying to do.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.