Tax Support Home Page | Contact Us | About Us

Online Discussion Forum For UK Tax Professionals and Accountants

Tax Support Forum logo
Welcome Guest! To enable all features please Login or Register.




Go to last post Go to first unread
Offline Bif  
#1 Posted : 06 November 2014 12:40:37(UTC)

Rank: Newbie

Groups: Registered
Joined: 06/11/2014(UTC)
Posts: 1
Location: York

Was thanked: 1 time(s) in 1 post(s)
Would be really hand to gather a list of useful Microsoft Excel formulas?

Anyone prepared to share hints and tips on MS Excel Formulas?

If have one to get us started...

Rounding to the results to the nearest hundred, thousand etc.

This is sometime useful in examples for clients or likely tax effects.

So for instance if I want to value a property by marking it up as a flat, say 5% rent yield as an approximate value in a potential CGT calc I do this.

Enter the annual gross rental income in field 1 (say A1)

Enter the yield I am using in field 2 (say A2)

In field 3 (Say A3) enter the formula =ROUND(field1/field2,0) to give value only rounded to £1 for reference purposes.

In field 4: =IF(A3>0,ROUND(A3,-3),0)

This will round the answer to the nearest thousand for the nearest hundred use -2 instead of -3 (see below)

The ROUND syntax is ROUND(Formula or Address,code)

code: 0 = nearest one place.
1 = nearest 1/10th
2 = nearest 1/100th
3 = nearest 1/1,000th
-1 = nearest ten's
-2 = nearest hundred
-3 = nearest thousand

You can nest the ROUND function as much as you want, to condition elements of your formula.

You can also use the INT formula to round up.

Hope that helps...


Edited by moderator 21 January 2015 13:33:37(UTC)  | Reason: typos

thanks 1 user thanked Bif for this useful post.
Mike on 30/12/2015(UTC)
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

The Tax Support Forum is aimed at UK tax professionals and accountants and it is free to participate.

No responsibility or liability whatsoever is accepted by, Tax Publications Limited or its associates or employees for any posts or comments in this discussion forum. It is meant for help and guidance only and if you are unsure of any aspects of tax we strongly recommend you seek the help of a suitably experienced and qualified professional. Remember that tax legislation changes frequently. Posts on this forum may have been superseded by later legislation or professional practice.

By using the Tax Support website you agree to using cookies. Cookies are small text files stored on your browser when you use websites and applications.

You can control how websites use cookies by configuring the privacy settings within your browser. See your browser help section for more information about cookie controls.

Note that if you disable cookies entirely parts of this website may not function properly.
Privacy Policy - Read more

© 2015 | All Copyright Reserved - A Tax Publications Website