Mathematical Font Presentation

norm282

New Member
Joined
Nov 11, 2002
Messages
22
Hi,

I'm using Excel 2002 with Windows XP. How can I write an equation in mathematical format.
For example:

b + (c)^n
a = --------
d

The equation doesn't look right but it is "a" equal to "b" plus "c" to the power of "n", all divided by "d".

Is there a mathematical font in Excel that makes this type of presentation and calculation possible?

Your help is appreciated.
Thank you
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Kavy

Well-known Member
Joined
Jun 25, 2007
Messages
607
Just Type in your cell

= # + #^#

The ^ symbol is regonized by excel
 

norm282

New Member
Joined
Nov 11, 2002
Messages
22
Kavy,
Thank you for your reply.

However, I am looking for more. I do not want simply to write the equation in one line and solve it, I am wondering if Excel has a means or a font will allow graphically presenting the equation as I have tried to describe it- and solving it.

This would also apply to more complex integral and differential equations.
 

Kavy

Well-known Member
Joined
Jun 25, 2007
Messages
607
Ah I still don't know what your really asking for, are you looking to show the equation one a graph?

As for intergal and diferential equaitons... I think you need Math Lab for that... if you want it done on a computer of course
 

norm282

New Member
Joined
Nov 11, 2002
Messages
22

ADVERTISEMENT

I have just been onto the internet and it looks like one has to buy the software for converting to math expressions. One ad says:

"the patented add-in automatically converts your formulas to textbook-style math notation allowing you to easily verify and manage your calculations every step of the way".

I was hoping that it might be in Excel.
Thanks for your help.
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,029
No. Excel does not support symbolic mathematics. You will have to look at a product like Mathematica or Maple or one of their competitors.
Kavy,
Thank you for your reply.

However, I am looking for more. I do not want simply to write the equation in one line and solve it, I am wondering if Excel has a means or a font will allow graphically presenting the equation as I have tried to describe it- and solving it.

This would also apply to more complex integral and differential equations.
 

jnewlin

New Member
Joined
Aug 2, 2007
Messages
18
Microsoft Equation 3.0

Microsoft Equation 3.0 is an object that can display equations in pretty font. The problem is, you must manually enter the numbers to use it. I'm trying to record a macro to fill in the values in the Equation 3.0 object, but as of yet have had no success.

To put an equation.3 onto your sheet, go to Insert -> Object -> Microsoft Equation 3.0.

If you know how to fill in an equation 3.0 object with values from a spreadsheet, please let me know!
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,896
Messages
5,834,288
Members
430,274
Latest member
TME1993

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top