Excel Magic Trick #233: 2 Business Math Tricks

[gadgethead16]

thanks it helped had took a while but i did it thanks

[sov19871987]

It is working now. Thank you (Oleg)

[ExcelIsFun]

EXCELlent!!

[RandyKelly19]

Do you have anything that covers exporting text and tables from excel into Outlook via a Macro into body of e-mail. Then hopefully be able to format the text and send the e-mail,

Thx for any help.

[ExcelIsFun]

I am not so good with Macros. But try this Excel site:

mrexcel..com/forum

Best Excel site EVER!!! This is where I go to ask questions when i do not know.

[malikg4u]

Hi

i live in uk and selfemployed can i use excel to calculate my tax return myself so i know how much i earn and how to much to pay tax to HM REVENUE IACTUALLY I WANT TO CALCULATE MY TAX PER YEAR.

yOUR VIDOES ARE GREAT

[artwithliam]

could i make a similar sheet which includes electronic transfers or would it overcomlicate things,

[ExcelIsFun]

Dear artwithliam,

Sure! Just add the column and then inlude it in the formula. Or you could just add the transfer in to the deposit column and transfers out to the Amount of Check column.

--excelisfun

[SirFranzOoTMM]

I learned all this in my Computing for college and careers class this year. (9th grade.) Man it's boring =|(not your vid the general work) Good vid though, tought it more simpfully than my teacher. 5/5

[ExcelIsFun]

Dear SirFranzOoTMM ,

Ok! I hope it was helpful.

--excelisfun

[planiolro]

Credit card fee cell has 4 decimals although you used round function to displays only 2 decimals.Why?

[ExcelIsFun]

Dear planiolro,

EXCELlent question!!!

For a real Invoice, I would not do this.

However, for this video I wanted to show that the ROUND function really does remove the extra digits!!!

--excelisfun