Grid with calculations structure suggestions?

[03Explorer]

I am trying to build a grid that has questions with six colums for responses. I combined the fifth and sixth column into one due to only one being populated per row.

Quetion1 vend Name; CSF; vf; total; b/c

Problem is CSF, VF, Total columns should contain currency, but percentages were allowed and text of 'Cost' also has been used. I would like to normalize the grid into a few tables (I used three in my last grid conversion) example:
note: FormID relates to rest of document with other grids
Example below had one type of data (currency)

tblResult
ID (autonumber-integer)
FormID (integer)
QuestionID (integer)
ColumnID (integer)
Value (currency)
b/c (integer) {1=b, 2=c}

tblQuestions
ID (autonumber-integer)
Question (text)

tblColumns
ID (autonumber-integer)
Name (text) {csf, bf, total)

Suggestions how to capture or hold the different 'values'?

 

[03Explorer]

Would it be a good option to make three fields to capture the expected types of data. Having the form decide by some method or selection which field to populate?

my thoughts(in blue)

tblResult
ID (autonumber-integer)
FormID (integer)
QuestionID (integer)
ColumnID (integer)
ValueCur (currency)
ValuePer (percent)
ValueTxt (text)
b/c (integer) {1=b, 2=c}