# [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?
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