Jump to content



Photo
- - - - -

Eact: Why Does Excel Not Recognize Variables?


  • Please log in to reply
1 reply to this topic

#1 Coaster

Coaster

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 05 January 2009 - 02:35 AM

Hi,

I'm working on an eActivity and I'm trying to make a summary table for some calculations I previously made. The best way to do this I thought would be an excel window because lists don't handle variables. The problem is that having defined a=1 previously, when I open excel and have a cell being =a, the output is 0...

Why can this be?

I've noticed that a variable such as a Matrix doesn't have this problem...Am I doing something wrong? Both the matrix and the number are defined the same way, with the command =>

Thank you

#2 Coaster

Coaster

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 05 January 2009 - 02:22 PM

well, I found a workaround...apparently excel only recognizes variables set in the "VAR" menu (the ones which appear as bold and italic), i'll have to deal with those!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users