answersLogoWhite

0

To get the equals sign to show in a cell you put the apostrophe before it. Anything after the apostrophe is taken literally and put into a cell. So to get the equals sign to show you put:

'=

The equals sign will then be displayed in the cell, without the apostrophe showing. You can use it to put in a full formula without the formula actually calculating. This is good if you want to see the formula and the result beside each other in two cells. Into one you put your formula starting with the equals and in the other the same formula with an apostrophe before it. In one it will do the calculation and in the other it will show the formula including the equals sign.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is the advantage of making foam?

u can insert it in your mouth


What are the two ways of making a textual presentation of a table?

1-From Insert Menu choose "Insert Table". 2-From slide content choose insert Table.


What is the formula for?

making


How do you find time from the formula Velocity equals initial velocity plus gravity times time squared?

vf=vi+at² simplifying making vi=0, v=at²t²=v/at=√v/atime equals square root of velocity divided by acceleration (or gravity)


When making an IF formula in Microsoft Eccel how to make your logical test equal two options ie D3 equals Asset i want if it also says credit so its like iF D3 equals credit or asset?

To test if D3 contains "Asset" or if D3 contains "Credit", then your formula should use the OR function and could be like this,: =IF(OR(D3="Asset",D3="Credit"), Do true thing, Do the false thing)


Making of ark welding rod chemical formula?

welding rod chemical formula?


How do you get a third of 100 without making 33.3 recurring?

Leave it in fraction form.1/3 of 100 equals exactly 100 x 1/3 = 100/3


You are making fortune cookies and typing fortunes to put on paper to insert in cookies Will that be poisonous?

no dude it wont


What is the formula for making cm2 to m2?

Divide by 10000.


How do you use Microsoft Excel to multiply numbers in A column and B column?

You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2You do it as follows, making sure the formula is not entered in cell A5 or cell B2:=A5*B2


Where should I put the thermometer in a chicken to ensure it is cooked to the correct temperature?

Insert the thermometer into the thickest part of the chicken, such as the breast or thigh, making sure it reaches the center without touching bone. This will ensure the chicken is cooked to the correct temperature.


Why is a formula such as C3H6O2 of limited usefulness?

A formula like C3H6O2 only provides the ratio of atoms in a molecule, making it ambiguous to determine the specific arrangement of atoms within the molecule. This limited information prevents the clear identification of the compound without additional details, such as structural or functional group information.