austenr
06-10-2010, 01:04 PM
This formula averages text box values. After entering 2 numbers say 88 and 90 the average says it is something like 445.
Anyone see anything wrong with this:
=IIf([BPSPF1Grade]>0,(nz([BPSPF1Grade])+nz([BPSPF2Grade])+nz([BPSPF3Grade])+nz([BPSPF4Grade])+nz([BPSPF5Grade])+nz([BPSPF6Grade])+nz([BPSPF7Grade])+nz([BPSPF8Grade])+nz([BPSPF9Grade])+nz([BPSPF10Grade])+nz([BPSPF11Grade])+nz([BPSPF12Grade])+nz([BPSPF13Grade])+nz([BPSPF14Grade])+nz([BPSPF15Grade])+nz([BPSPF16Grade])+nz([BPSPF17Grade])+nz([BPSPF18Grade])+nz([BPSPF19Grade])+nz([BPSPF20Grade])+nz([BPSPF21Grade])+nz([BPSPF22Grade])+nz([BPSPF23Grade])+nz([BPSPF24Grade])+nz([BPSPF25Grade])+nz([BPSPF26Grade])+nz([BPSPF27Grade])+nz([BPSPF28Grade])+nz([BPSPF29Grade])+nz([BPSPF30Grade]))/[PFNum],0)
Anyone see anything wrong with this:
=IIf([BPSPF1Grade]>0,(nz([BPSPF1Grade])+nz([BPSPF2Grade])+nz([BPSPF3Grade])+nz([BPSPF4Grade])+nz([BPSPF5Grade])+nz([BPSPF6Grade])+nz([BPSPF7Grade])+nz([BPSPF8Grade])+nz([BPSPF9Grade])+nz([BPSPF10Grade])+nz([BPSPF11Grade])+nz([BPSPF12Grade])+nz([BPSPF13Grade])+nz([BPSPF14Grade])+nz([BPSPF15Grade])+nz([BPSPF16Grade])+nz([BPSPF17Grade])+nz([BPSPF18Grade])+nz([BPSPF19Grade])+nz([BPSPF20Grade])+nz([BPSPF21Grade])+nz([BPSPF22Grade])+nz([BPSPF23Grade])+nz([BPSPF24Grade])+nz([BPSPF25Grade])+nz([BPSPF26Grade])+nz([BPSPF27Grade])+nz([BPSPF28Grade])+nz([BPSPF29Grade])+nz([BPSPF30Grade]))/[PFNum],0)