Search This Blog

June 28, 2014

Round to nearest 0.50

The Mround function will do what you want.

=Mround(1.25, 0.5) returns 1.5


Returns a number rounded to the desired multiple.



Number   is the value to round.

Multiple   is the multiple to which you want to round number.


MROUND rounds up, away from zero, if the remainder of dividing number
by multiple is greater than or equal to half the value of multiple.


MROUND(10, 3) equals 9

MROUND(-10, -3) equals -9

MROUND(1.3, 0.2) equals 1.4

MROUND(5, -2) equals #NUM!

June 16, 2014

Forms for Elections

Form-6 - Application for inclusion of name in electoral roll
FORM 6A - Application for inclusion of name in electoral roll by an overseas elector
FORM 7 - Application for objecting inclusion or seeking deletion of name in electoral roll
FORM 8 - Application for correction to particulars entered in electoral roll
FORM 8A - Application for transposition of entry in electoral roll..

June 6, 2014

Vaccancy Allowance u/s 23(1)(c)

The tax is levied on the income-earning potential of the property, and not on the income generated from the property. However, if the property is let out and is vacant for a part of the year, the assessee is entitled to proportionate relief called "vacancy allowance" under Section 23(1)( c) of Act.

Vaccancy Allowance u/s 23(1)(c)

Where let out property is vacant for a part of the year and owning to vacancy, the actual rent is lower than ALV, then the actual rent received or receivable will be GAV of the property.

Provisions of Section 23(1)(c) dealing with vacancy allowance applies only to a property which is let out – Self-occupied property is not eligible for vacancy allowance

Where the property has not been let out at all during the year, there is no question of granting any vacancy allowance under Section 23(1)(c) – Period for which a let out property may remain vacant cannot exceed period for which property has been let out