PDA

View Full Version : Quartiles with N/A



PV24
01-11-2016, 02:46 PM
Is there a way to force an Excel VBA macro to perform a quartile operation on a range that includes #N/A or blank spaces?

Any help is appreciated!
Thanks

SamT
01-11-2016, 04:11 PM
I had no problem with blanks, If you're seeing #N/A then it is a formula. Change the formula to handle errors gracefully

=IF(ISERROR(OriginalFormula,"",OriginalFormula)