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

[Lars Jensen]

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?

Thanks,
Lars.


--
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