Excel: Adapt Formula to Ignore ZERO Value


Hi All, Does anyone know what additions I need to make to the following formula in order for the range that is being looked at to ignore any 'Zero' value? Thanks in advance, =IFERROR(1-PERCENTRANK.INC($B$27:$B$100,$A$14,3),"")


This question generated 27 answers. To proceed to the answers, click here.

This thread is current as of March 09, 2017.


For more resources for Microsoft Excel