Taking Deflaut value as 10 in out put table.

gaurav - May 4, 2012 at 04:09 AM
 Josh - May 4, 2012 at 12:38 PM

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 backend 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.

Can U help me please!

2 replies

Maybe try to count the non-empty cells and then multiply that number by 10?
Registration date
Thursday January 28, 2010
Last seen
May 5, 2022
May 4, 2012 at 06:31 AM
I am sure this question is making total sense to you. But I for one, do not get what is this "numeric values in the backend" and as a whole I am at lost what exactly are you asking.
May be you should post a sample workbook at some file share site and post back the link to the file back here. Using that file as reference, it might be easier for you explain the issue and others to understand