formulas
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

resolvedResolved · Medium Priority · Version 2007

replyReply Mon 12 Jan 2009, 16:02Delegate Zita said...

Zita has attended:
Powerpoint Introduction course
Excel Intermediate course

Formulas

How to create formulas on dividing and multiplications on excel.

For upcoming training course dates see: Pricing & availability

replyReply Fri 16 Jan 2009, 10:04Trainer Mark said...

RE: Formulas

Hi Zita

Thanks for your post and welcome to the forum

I have listed a few example formula's for you to try out below

1. =b4/15%
2. =B5+d3/d6
3. =sum(b2:b10)/12.5
4. =b15*d4*h5/1.25

The above examples are a combination of adding, dividing, and multipying in some different ways try them out if you get any trouble with these let me know

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Thu 22 Jan 2009: Automatically marked as resolved.

 

Please browse our web site to find out more about
ms excel training and other Microsoft training courses.

Excel tip:

Currency format

Ctrl+Shift+$ applies the Currency format, with two decimal places

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard