Ratio

Resolved · Medium Priority · Version 2010

Fri 24 Jan 2014, 13:24 Delegate Richard said...

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

Fri 24 Jan 2014, 14:42 Trainer Gary said...

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

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

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.