Hope I am posting this under the right catergory. I would greatly appreciate assistance with the below please.
I need to take a column of values from excel cell F2.  in this case.
Multiply F2 by 100;
Divide the result by cell G2; 
Final answer to be placed in cell H2.
I used an assign statement as per below:
perMaxHR = Convert.ToInt32(row(5))*100/Convert.ToInt32(row(6))
But i keep getting an error: Object cannot be cast from DBNull to other types.
This only happens when i divide the result by cell G2.
If i divide the result by cell A1 for example then everything works fine. I would really apprecite your assistance. Thanks in advance.