Browsed by
Tag: if()

In Excel, how to use If function with 3 conditions?

In Excel, how to use If function with 3 conditions?

Here is one data. P-values are summarized for genotypes at difference fields. Now I’d like to add symbols; *,**,*** and n.s. If p-value is less than 0.05, it will be *, and if p-value is less than 0.01, it will be **, and if p-value is less than 0.001, it will be ***, and if all conditions are not met, it will be n.s. So, I’ll add this code in D column in the excel, and drag this code to…

Read More Read More