microsoft excel training in london - visal basic myfunction formula

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training in london - Visal basic Myfunction formula

microsoft excel training in london - Visal basic Myfunction formula

resolvedResolved · Low Priority · Version Standard

Gary has attended:
Excel Intermediate course
Excel Advanced course

Visal basic Myfunction formula

When using visal basic Myfunction formulas during my course on the 18/01/2008 with Pete Emmerson I asked the following question.

When pulling a % through to excel there were decimal places I would like to round. e.g so that in the excel spreadsheet it displays 40% not 40.52. Please could you tell me how to display this number as 40%.

RE: Visal basic Myfunction formula

Dear Gary

Thank you for attending Excel Advanced Course.

I have uploaded an Excel File MyFunction that I created for your reference.

Step 1: I created the [b]


 

Excel tip:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips


Server loaded in 0.11 secs.