Conditional message with REPT function
This formula uses boolean logic to output a conditional message. If the value in column C is less than 100, the formula returns "low". If not, the formula returns an empty string ("").
Boolean logic is a technique of handling TRUE and FALSE values...Read more