Excel Magic Trick #233: 2 Business Math Tricks

See how to create an efficient Checkbook Balance Formula and see when to use ROUND on a Sales Invoice.
Learn how to create a checkbook balance formula 13 times faster than most people.
Learn when you must use the ROUND function and when you dont have to.

Category:

Science & Technology

Tags:

• Excel
• checkbook
• balance
• formula
• efficiency
• ROUND
• function
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[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.

[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

[gadgethead16]

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

[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

[ExcelIsFun]

Dear SirFranzOoTMM ,

Ok! I hope it was helpful.

--excelisfun