Skip navigation
pdfdummy
Currently Being Moderated

Fillable form calculations.

Apr 19, 2012 2:03 PM

I am having some trouble and am new at this. I have a fillable document that I have completed minus (which I guess is the hardest part) the correct formula. I have made an audit for my company months ago using excel and have been doing it via paper for sometime, well about a year. I am not sure what to do about getting this formula right.

 

Here is what is going on

I have boxes that get an x marked if passing to be a value of 1. lets say there are 20 different boxes per section that can be marked, each with a value of 1.

Within each section I would like to give a score that would refect

a.) The sum  

b.) The avg in percent

which both of these I have boxes ( seperate) in each section of the audit that are designated to this alone.

in the calculations section I have the formulas set up to the sum fillable boxes that are checked

More or less Im pretty sure that I need to give a value to x but I am not sure how to do this.

 

Thanks

PDFDUMMY

 

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points