Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
1999
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 1999

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Mathematica Link for Excel

  • To: mathgroup at smc.vnet.net
  • Subject: [mg18180] Re: [mg18085] Mathematica Link for Excel
  • From: Haiduke Sarafian <has2 at psu.edu>
  • Date: Sat, 19 Jun 1999 23:54:35 -0400
  • Sender: owner-wri-mathgroup at wolfram.com

At 12:26 PM 6/17/99 -0400, nogueira wrote:
>
>Dear Mathematica users
>
>I just installed the math link(v:2.0.0)  for excel (97) but
>when I type a function in an empty cell, like
>=Math("Cos",3),  it comes an Excel error message
>like "The formula you typed contains an error".
>It does work if I go by the "function wizard".
>Does anyone know how to fix this problem?
>
>Thanks for your attention
>
>Eduardo
>xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>Eduardo Arantes Nogueira       nogueira at hc.unicamp.br
>Laboratorio de Cateterismo Cardiaco
>Universidade de Campinas, Brazil


This is the way it works.  =Math("Cos",b1) where b1 is predefined cell, say
3.  To check the validity of the calculation instead of 3, evaluate the
Cos(30 degrees).  So enter in b1 the following:  =PI()/180*30 and then in
an empty Excel cell enter  =Math("Cos",b1) this will give 0.86.
Alternatively , you may replace your entry   =Math("Cos",3)  with
=Math("Cos","3")  .  Cheers
> 





  • Prev by Date: Plotting discontinuous lines
  • Next by Date: Re: MS Word Front End
  • Previous by thread: Re: Mathematica Link for Excel
  • Next by thread: Options for a function