excel classes - excel fomular
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 » excel classes - Excel fomular

excel classes - Excel fomular

resolvedResolved · Low Priority · Version Standard

replyReply Thu 15 Nov 2007, 17:05Delegate Daniel said...

Daniel has attended:
Excel Intermediate course

Excel fomular

can you please tell me what the calculating formulars are for
adding, subtracting,dividing and miltiplying please?

For upcoming training course dates see: Pricing & availability

replyReply Fri 16 Nov 2007, 10:38Delegate Paul said...

RE: Excel fomular

=(A1+A2)
=(A1-A2)
=(A1/A2)
=(A1*A2)

 

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

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