Using Google Forms for a quiz...
The quiz is graded /30.
Value is transmitted into Google Sheets.
C2 displays a value of grade... here,
14/30 (as an example)
Value for cell
C2 reads as
Attempting to get the value of
D2 to show a mark on 100...
=C2/30 (this should give me
46.6%) but it returns a value of
Why won't it pick up the value of
C2 as the value
14 it shows in the fx-box?
How can I get it to pick up the value from the cell to then perform more functions?