- Home/
- PRT, TGT & PGT Exams/
- Article
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.
