DELTA() function

Functions Jun 26, 2019

About  DELTA() function

The DELTA() function is an Engineering function that returns a Boolean value either 1 or 0 for the supplied numbers are equal or not. It contains 2 arguments and they are number1 and number2.

Where to apply :

This function is used by engineers and in education also wherever it needs to check whether the values are same or not.

Syntax :

=DELTA(number1, number2)

Parameters :

number1- Any number

number2 - Any number


1. For the number 16 and 16.

=DELTA(16, 16)    // Returns (1)

It returns 1 for numbers 16 and 16.

Excel based example:

Image 1 - DELTA() Function

The DELTA() function is well explained in above image.

Hope, it would have added in your Excel function knowledge.

Thank You!

Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.

If you want to learn Excel & VBA courses to be Excel expert, connect us on:

9599408486 / 8929231250

Manoj kumar

Corporate Trainer at ExcelHour. I have devoted over 9 years to various industries for learning multiple data challenges and trained Excel and VBA courses to the corporate along with offline training.

Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.