ratio

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

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Ratio

Ratio

resolvedResolved · Medium Priority · Version 2010

Richard has attended:
Excel Advanced course

Ratio

Trying to display a ratio. I would like the standard ratio format e.g. 1:2 and the numbers to be rounded to whole units and in their lowest form.
At the moment i get long numbers which look meaningless and long decimals e.g.234.2345:5678.567

Please could you help with an excel solution and a VBA solution.

Thanks

RE: Ratio

Hi Richard

Thanks for getting in touch. Is the ROUND suite of functions any use to you?

You use them like so:

=ROUND(300.125,2)

Will result in 300.13

=ROUND(299.44,0)

Will result in 299

=ROUND(299.8,0)

Will result in 300.

There are also ROUNDUP and ROUNDDOWN which round up or down respectively as required.

You can also embed cell references and other functions inside the formula.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 31 Jan 2014: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips


Server loaded in 0.08 secs.