Excel PERCENTILE and IF function basics. The PERCENTILE function in Excel helps you find the K percentile in a set of values. For instance, you’d use this function to see which Salespeople are in the ...

Enter the following formula in cell D2: =IF(C2,B2/C2,"") Use If to Show a Blank Cell in Place of a #Div/0! Error; You will see a blank cell in cell D2. In this case, the formula states that if the C2 ...

If your population size is known and not too large, you can use the following adjusted formula to find your sample size: n_adjusted = n/ (1+(n-1)/N) where: – n_adjusted is the adjusted sample size – n ...

This is the demonstration file to accompany the article, How to split a column using an IF() function in Excel, by Susan Harkins.

Writing Excel formulas isn't easy if you don't speak the language. Fortunately, at least two sites will translate your request, in English, into Excel code.