# Need Excel 2007 to do: If D6=0, then F4=F4+.5 February 19, 2011 at 06:34:53
Specs: Windows Vista
 This is a school spreadsheet--when a student finishes a module, it is subtracted from total modules in unit. When unit complete ("0"), student receives .5 credit."F4" is sum of all .5 credits(could do this formula YEARS AGO on Lotus 123!) See More: Need Excel 2007 to do: If D6=0, then F4=F4+.5

#1 February 19, 2011 at 10:03:43
 Could you please explain in a little more detail how you would like the sheet set up?It is unclear to me what this means, in terms of it being in a spreadsheet:when a student finishes a module, it is subtracted from total modules in unit.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

#2
February 23, 2011 at 02:05:03
 Class Modules Completed Remaining[cell B6]English III Sem I 47[C6] 47[D6] 0[E6]English III Sem 2 34 34 0History Sem 1 24 22 2History Sem 2 18 0 18 So, when "Remaining" = 0, 1/2 credit is awarded.Total credits earned [cell F4]If E6 = 0 then "credit" = .5, if F6 = 0 then "credit" = .5 so F4 formula result would then equal 1.Would like formula so find (count) all zeroes in column 6 (number of zeroes), multiply by .5 to give total credits earned.Now it is part of a text file, so teachers have to manually change number of credits when a section has been completed.the "if E6 = 0 then .5" could be hidden on sheet (not part of form that is printed), as long as F4 shows total credits earned.(this happens in a couple of different places, depending on what part of the curriculum is being completed.)

Report •
Related Solutions 