[LON-CAPA-users] Spreadsheet formual?????
Sat, 25 Jan 2003 19:56:41 -0500
I'm probably not the best to answer this, but I am geeky enough to be
reading this on a Saturday. I'd try:
( X# == 5 ? X# : 0 )
Lars Jensen wrote:
> 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: <email@example.com>, http://www.scsr.nevada.edu/~jensen
> Tel: 775.673.7113 FAX: 775.674.7592
> LON-CAPA-users mailing list
Michigan State University