Form Template/Data Tracking issues

Mtaylorlc

New Member
Joined
Mar 31, 2002
Messages
42
I have a checklist form that I am developing. It has about 90-100 yes/no questions in 10 different categories. For each category I have a formula that calculates the % of positive responses. I have generated a summary row at the bottom of the sheet to list a few text entries by cell reference, the numerical values from the % of positive reponses (by cell reference), and an overall average of the % of positive responses. As I am defining the cells and field names I get a Type mismatch error (13) when entering my first numeric cell reference. I have tried just transfering the text values and that is working, but I need to be able to transfer the text cells as well as the numeric. Any ideas?
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
FYI,

When assigning the reference cells on a blank form a #DIV/0 will cause the Type Mismatch (error 13). I resolved the issue by changing the formulas from

=G12/(G12+H12)*100 [results in #DIV/0]

to

=G12/(G12+H12+0.0001)*100 [results in 0]

This allows formatting the innitial template blank rather than having to enter bogus data.

:biggrin:
 
Upvote 0

Forum statistics

Threads
1,213,484
Messages
6,113,923
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top