Advertisement

Member Login


Or call us
US +1 (617) 500-8224
EU +44 (113) 815 2220
Or Skype us

Who's Online

We have 19 guests and 2 members online


Enter Amount:


Total Downloads

156789
Home arrow Showcase arrow Division Line Position Functions

Division Line Position Functions

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().

 

Please sign in or register to add a comment.