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

[Felicia Berryman]

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?
> 
> 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
> 
> _______________________________________________
> LON-CAPA-users mailing list
> LON-CAPA-users@mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users



-- 
Felicia Berryman
LON-CAPA Coordinator
Michigan State University
   Email:  felicia@lon-capa.org
   Phone:  (517)432-9866
http://www.lon-capa.org