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

Report •

#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 0
History Sem 1 24 22 2
History 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


Ask Question