# Formulas in Excel Begins with

By BYJU'S Exam Prep

Updated on: September 13th, 2023

The equal sign (=) appears at the start of every formula in Excel. This formula is employed to carry out calculations within the cells of an excel spreadsheet. The formula bar at the top of an Excel sheet is where we can enter the formulas we want to employ for our calculations.

Table of content

## Answer – Formulas in excel begins with equal sign (=).

You might be shocked to learn that dates and numbers cannot be compared using the Equal to the logical operator. For instance, the formula =A1=A2 will yield True as it should if the cells A1 and A2 contain the date 12/1/2022.

On the other hand, if you attempt =A1=12/1/2022 or =A1=12/1/2022, you will receive the error False. Excel records data as numbers starting with 1-Jan-1900, which is kept as 1. This is the key point. 12/1/2022 is saved with the number 41974. Since 12/1/2022 is not equivalent to 41974, Microsoft Excel reads it as a regular text string in the aforementioned calculations and returns False. Always enclose dates in the DATEVALUE function for the right outcome, as in =A1=DATEVALUE(12/1/2022).

Summary:

## Formulas in Excel Begins with

Formulas in excel begins with equal sign (=). The formula bar at the top of an Excel sheet is where we can enter the formulas we want to employ for our calculations.

### Recent Posts

POPULAR EXAMS
SSC and Bank
Other Exams
GradeStack Learning Pvt. Ltd.Windsor IT Park, Tower - A, 2nd Floor, Sector 125, Noida, Uttar Pradesh 201303 help@byjusexamprep.com