Imagine I have 10 columns and I wish to calculate the standard deviation. However, I want to exclude a certain value from the calculation due to error in data.

Here is the formula and I want to exclude if the value is=100.
How do I do that.
=STDEV.S(A2:C2)

Thanks, seems to work fine. How would this work if I had multiple values that I want to exclude. For example value 98, -1 and 100.
Of course I can write
STDEV.S(IF(A2:C2<=100,A2:C2))
But I want to learn with multiple IF.