Identifying Formatting in Excel

[MrsNic]

I have set up an electronic markbook in Excel, that will automatically produce reward cards for students that have achieved the correct number of A grades. Is there a way I can format the grades that have been 'used' so they are not counted the next time?

Many thanks

 

[Gavona]

If you need 3 Agrades for a reward then you want to produce a reward whenever the number of rewards is exactly divisible by 3 i.e.
Agrades / 3 = round(Agrades /3,0)

If the next test got a B then a formula based on the above would still be true.
I suppose:
If(and(ThisTest=A,Agrades / 3 = round(Agrades /3,0),"Well Done! You get a reward","no reward yet")

Maybe bBetter to record in the markbook that a reward has been given but how excactly depends on the structure of your markbook.
Are you using code to automatically produce a reward card?

Hope this helps.

Thanks,

Gavin

 

[SkipVought]

Hi,

Have a Date column. The use the Data/AutoFilter - custom to select grades Greater Than or Equal to an appropriate value.

Skip,

_{[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie!}