Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 -- novastar |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You can either do it by inserting symbols as appropriate, or Insert - Object
- Microsoft Equation x.0 (x being a version number) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "novastar" wrote: 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 -- novastar |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? -- novastar "Luke M" wrote: You can either do it by inserting symbols as appropriate, or Insert - Object - Microsoft Equation x.0 (x being a version number) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "novastar" wrote: 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 -- novastar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell changes to a formula after hitting ENTER | Excel Discussion (Misc queries) | |||
Alt+Enter works in the formula bar, but not in the cell | Excel Discussion (Misc queries) | |||
how to use a cell to enter a filename in a formula | Excel Worksheet Functions | |||
Cannot enter formula in a cell after removing a circular formula | Excel Worksheet Functions | |||
how to enter a null cell value in a formula | Excel Worksheet Functions |