Taking Deflaut value as 10 in out put table. Closed

Question

Hello, 

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!

rizvisa1 · Answer

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

Josh · Answer

Maybe try to count the non-empty cells and then multiply that number by 10?

Taking Deflaut value as 10 in out put table.

2 responses

Similar discussions

Subscribe To Our Newsletter!