C
Chartswife
Im running vista, microsoft office pro 2007
I'm trying to write a workable formula in an unbound text in form design.
It's a monster formula.
Their are 4 components:
comp/att*100-30/20
yds/att-3*.25
td/att*20
2.375-int/att*25
Each one of the answers for these 4 components must be checked , if greater
than 2.375 then set to 2.375 and if less than 0 then set to 0
and finally, all added together, multiplied by 100 and divided by 6
This is what I have but I get Syntax Error. I'm very new to access, so
please keep this in mind, thank you.
=PasserRating[comp]/[Att]*100-30/20+iif(>2.375=2.375),iif(<0=0)+[yds]/[att]-3*.25+iff(>2.375=2.375),iif(<0=0)+[td]/[att]*20+iif(>2.375=2.375),iif(<0=0)+(2.375-[int]/[att]*25),iif(>2.375=2.375),iif(<0=0)*100/6)
I'm trying to write a workable formula in an unbound text in form design.
It's a monster formula.
Their are 4 components:
comp/att*100-30/20
yds/att-3*.25
td/att*20
2.375-int/att*25
Each one of the answers for these 4 components must be checked , if greater
than 2.375 then set to 2.375 and if less than 0 then set to 0
and finally, all added together, multiplied by 100 and divided by 6
This is what I have but I get Syntax Error. I'm very new to access, so
please keep this in mind, thank you.
=PasserRating[comp]/[Att]*100-30/20+iif(>2.375=2.375),iif(<0=0)+[yds]/[att]-3*.25+iff(>2.375=2.375),iif(<0=0)+[td]/[att]*20+iif(>2.375=2.375),iif(<0=0)+(2.375-[int]/[att]*25),iif(>2.375=2.375),iif(<0=0)*100/6)