I would like to create an If/Then formula where I have a column of data (1 = yes) and (0 = No) where some cells are blank. Meaning there was neither a yes or no answer. I want to only calculate the percentages of the actual answers, not including the blank cells. How would I write a forumla for If cell is blank do not count it ... ? Have I said this correctly?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
If "blank" then don't count in percentage calculation
- Thread starter mbritt
- Start date
Excel Facts
Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Similar threads
- Solved
