I want to create a excel sheet in which there will be some column which will get the input in alphabets and numeric values. The last column will be for total. Irrespective of any alphabets and numeric values in the back-end the excel should take 10 by default and if the cell is left blank then it should take value as 0. So in the total it should only add 10 for every cell, which have some alphabets and numeric values.
