[LON-CAPA-users] (no subject)

Guy Albertelli II lon-capa-users@mail.lon-capa.org
Mon, 22 Jan 2007 01:57:09 -0500 (EST)


Hi Brew,

> I am playing with my scoring mechanism in the spreadsheet again, and tried
> the line below.
> It of course gives the standard "undefined value" response.
> 
> Anyone know what the error is?
> 
> The stores_0_tries value is blank or empty; all the rest of them have
> numbers in them.
> 
> [&EXPANDSUM(PART;stores_PART_tries=1?6:(stores_PART_tries=2?2:(stores_PART_tries=3?0:-2)))]
> 

Try this:
 [&EXPANDSUM(PART;stores_PART_tries==1?6:(stores_PART_tries==2?2:(stores_PART_tries==3?0:-2)))]

( '=' is assignment, '==' is numerical comparison, 'eq' is text comparison )

-- 
guy@albertelli.com   0-7-1-6-27,137