[LON-CAPA-users] Spreadsheet formual?????

Lars Jensen lon-capa-users@mail.lon-capa.org
Sat, 25 Jan 2003 16:46:15 -0800 (PST)

I'm trying to create a formula for the spreadsheet. I'm in the middle
level of the spreadsheet (user level). I'm tryinf to enter a formula in
the cell template_a, ,and the formula shoulld result in a 5 if X# is 5
and a 0 if it is not. I tried several variations of this:

I tried several variations of this:

( X# = 5 ? X# : 0 )

but nothing works.

Any ideas?


Lars Jensen, TMCC/Vista B200, 7000 Dandini Blvd, Reno NV 89512-3999. 
Internet: <jensen@physics.unr.edu>, http://www.scsr.nevada.edu/~jensen
Tel: 775.673.7113  FAX: 775.674.7592