grade calculation when source cells are empty

grade calculation when source cells are empty

by Keith Landa -
Number of replies: 0

I'm using the calculation:

=floor((item1+2)/5)

to convert item1 into a new item with a 1 if the original score is 3 to 5, and 0 if the original score is less than 3.  That all works fine.  

However, an empty score for a student in item1 leads to an empty score in the calculated item.  I want empty scores in item1 to be 0's in the calculated item, without me overriding the empty scores in item1 with 0's.  (As I want students to still be able to work on item1 if they haven't already, but see a 0 in the calculated score to motivate them.)

I tried

=if(item1, floor((item1+2)/5), 0)

but that still left empty scores in the calculated item when there were empty scores in [[item1].

Any way for me to do a calculation that puts 0's in for empty scores in the source item, but also does the calculation if there is a score in the source item?  Thanks.

keith landa

purchase college suny