answersLogoWhite

0


Best Answer

If you mean "spreadsheet program", not necessarily. That's a standard used in Excel; in older spreadsheets, such as Lotus 1-2-3, the formula used to start with a plus sign instead. A minus could be used as well, if it was appropriate for the formula. However, nowadays it seems to have become quite standard for formulae to start with an equal sign.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Do a formula has to have an equal sign in every spreadsheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What a formula always begins with?

Type = (equal sign) to begin a formula on a spreadsheet.


What is the symbol you must enter first when creating a formula in a spreadsheet?

The equal sign(; ( = )


What should you start every formula with?

equal sign


What signifies that a cell in a spreadsheet is a formula?

A symbol at the beginning of a formula identifies the entry as a formula instead of a label. In an entry of =B3+C3, the equal sign identifies the entry as a formula.


When keying a formula in a spreadsheet what must you key to inform the program that you are entering a formula instead of entering text?

An equal sign because in order for the formula to go through correctly it has to have an (=)


What do you use to calculate things in spreadsheets?

Every formula starts with equal sign =If you want to display list of all functions in Excel from the upper toolbar select: Insert - Function.


What must you type to start off a formula in Excel?

Excel formulas begin with an equal sign, for example:=SUM(A1:A7)will give you the total of the numbers in cells A1, A2, A3, A4, A5, A6 and A7.Array formulas start with = but are enclosed in brace bracket{}.You can also use the plus or minus sign to start a formula, but as soon as you press Enter, a plus will be converted into an equals sign and a minus sign will have an equals sign inserted before it, so the formula will still show as starting with an equals sign.+5+7 will become =5+7-10*2 will become =-10*2Lotus 123 was the big spreadsheet application before Excel. It used the @ sign to start its functions. In order to help people moving from using Lotus 123 to Excel, the ability to start functions with the @ sign was included in Excel, and you can still do that. This applies only to functions at the start of a formula, not any formula.


How are formulas created in Excel?

Every formula, equation, or function starts with a equal sign in a given cell.


Does equal sign proceeds a formula?

If you mean in Excel, yes: you must always start a formula with an equal sign.


Does a formula have equals SIGN in it?

In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.


What does equal plus mean in excel?

The combined sign has no special meaning. Any formula in Excel starts with an equal sign. To refer to a cell, you can write, for example, =A1. This can also be written as =+A1. The "+" isn't really necessary in this case. Most likely, a user started the formula with a "+" (out of old habit, since that's what people used to do in older spreadsheet programs), and Excel added the equal sign, which is required in Excel, automatically.


Which sign is called the formula prefix?

equal sign (=)