•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
StDev formulas all giving #DIV/0! despite no "0" or error cells
In column H I have an average speed calculated using columns E and F, whilst excluding outlier values. I am using the formula below:
=IF(AND(160>F3/(E3/60),F3/(E3/60)>0),F3/(E3/60),"")
On another sheet in cell "C5" I am trying to find the SD of column H using the formula:
=STDEV.P('EV Data'!H3:H100000)
The #Div/0! error keeps coming up despite there being no zeros due to the formula in column H. I have also checked using the filter function and there are no ERROR, DIV/0!, or N/A cells in column H. Any help would be greatly appreciated. TIA
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#Excel alternatives for data analysis
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#StDev
##DIV/0!
#average speed
#outlier values
#formula
#SD
#filter function
#ERROR
#N/A
#cells
#columns E and F