-
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.
zero error
-
L
Formula for average to exclude cells with no number/text?
Hello, I have a formula to average a range of cells (ex. =AVERAGE(E2:AG2)) but some of the cells in that range do not have any data and just have a dash "-" to represent that it's not left unintentionally blank, but that we just don't have a data point for that cell. This is done across 300+rows...- lichldo
- Thread
- average formula zero error
- Replies: 1
- Forum: Excel Questions
-
K
Allowing multiple zeroes
Hello, I have a sheet where values are entered into one cell and if they match a criteria a results cell allows pass or fail. e.g. a value must be between 1-5, if it is within this range, Pass, otherwise Fail. However one cell must match 00000000, the issue is that this changes to just 0 when...- koconnell
- Thread
- excel 2010 format cells zero error
- Replies: 3
- Forum: Excel Questions
-
K
Get rid of the percent symbol or help with (#DIV/0!)
Help....I have a column that is the sum of 2 other columns. I need it to list as a percentage, but without the percentage symbol. I used the formula of dividing one cell against the other than times it by 100. [ie. (A1/A2)*100], which works. However when the value is 0 (ie. 10/10) then I get...- kkmatheso
- Thread
- get rid of % get rid of percent symbol percentage format percentages zero error
- Replies: 5
- Forum: Excel Questions
