How to enter a formula in a cell?

N

novastar

Hi there,

I am trying to create a table in Excel with the following format, where "C",
"Roots", "Area of a Triangle" are in one column and the equations are in
another column. In "Word" it is easy to enter a formula by "Insert->
Equation". How does one do it in excel?

C = √(a^2+b^2 )
Roots = x=(-b±√(b^2-4ac))/2a)
Area of a triangle = 1/2*b*h
 
L

Luke M

You can either do it by inserting symbols as appropriate, or Insert - Object
- Microsoft Equation x.0
(x being a version number)
 
N

novastar

Hi Luke M,

THis puts the equation as an object and is not part of a cell.
Is there a way to enter an equation in a cell?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top