Advertisement

Member Login

Who's Online

We have 5 guests and 15 members online

Enter Amount:


Total Downloads

141968
Home arrow Showcase arrow Division Line Position Functions
Division Line Position Functions  E-mail

XLC has some special functions to control what is displayed above and below a division line in an equation.

Image 

Notes

The OVD() function places everything inside of the brackets over the division line. A division character "/" must immediately follow the closing bracket of an OVD() function. An OVD() function is always followed by a UND() function.

The UND() function places everything inside of the brackets under the division line. A division character "/" must be immediately before a UND() function. An UND() function is always preceded by a OVD() function.

Failure to position the functions in this order OVD()/UND() will result in the following error "#OVD()/UND() function misuse. Check that OVD() occurs immediately before / and UND() occurs immediately after /.#"

OVD()/UND() functions cannot be nested. 

German Version of Excel

UND() is used as the logical AND() function in German versions of MS Excel. To prevent conflicts:

    UDI() can be optionally used in place of UND().

    and for the sake of consistency ODI() can be optionally used in place of OVD().

Last Updated ( Friday, 21 December 2007 )
 
< Prev   Next >