Why not use Excel as your calculator?

re: Why not use Excel as your calculator?

ShelLuser — Wed, 31 Aug 2011 01:09:43 GMT

Very cool entry, I actually learned something new here. Thanks!

re: Why not use Excel as your calculator?

Gary Willoughby — Mon, 29 Aug 2011 15:56:54 GMT

@novice: Assuming your first amount ($80) is in cell A2, you could enter these formulas in cells B2, C2, and D2:

=A2*1.05

=A2*1.1

=A2*1.6

Then, drag the formulas in these cells down into the cells below them. They'll calculate $80 plus 5% (that is, 105% of $80), $80 plus 10% (110%), etc. Hope this is what you had in mind. If not, you can post your question at the Microsoft Answers Forum for Excel:

answers.microsoft.com/.../office_2010-excel

re: Why not use Excel as your calculator?

novice — Mon, 29 Aug 2011 05:58:16 GMT

Being a novice to excel and reading soo much it's just going over my head trying to absorb soo much for probably such a simple formula that i cannot formulate.Having a price list for example and 100's of numbers down a page a formula for eg is needed of such as; $80+5%+10%+60%. where the $ will of course change regualrly but not the %'s. Could u please help as to how to do this on excel 2007.

Thank you for your time

re: Why not use Excel as your calculator?

Jspangenberg — Sat, 27 Aug 2011 02:38:49 GMT

@veeyoes: I can make a converter function if you are still interested/in need and can list more details... let me know

re: Why not use Excel as your calculator?

Gary Willoughby — Thu, 25 Aug 2011 18:20:00 GMT

@veeyoes: My awesome colleague Anneliese happened to see a similar question posted in another forum and, seeing your comment, sent me this link to an article at the Microsoft Support Center. The VBA code in the article converts a number such as 32.50 into "Thirty two dollars and fifty cents." If you don't need it expressed as currency, you can change some of the code. Anyway, here's the link to the Knowledge Base article:

support.microsoft.com/.../213360

If you want to change the code and need some help with it, you may want to post your question at the Microsoft Answers forum for Excel:

answers.microsoft.com/.../excel

re: Why not use Excel as your calculator?

veeyoes — Thu, 25 Aug 2011 05:20:49 GMT

Hi, Is there any formula in Excel for converting number to word (eg. 1234 as One thousand two hundred thirty four)?. Please comment