If formula with greater/less than

jhahnlee

This is probably a fairly basic question, but I'm having trouble creating a formula saying "IF the value of specific column is less than 45 then make column say YES, and NO if greater than 45"

Tomasz Giba

=IF([specific column]@row<45,"YES",IF([specific column]@row>45,"NO","VALUE IS 45"))

Tomasz Giba

=IF([specific column]@row<45,"YES",IF([specific column]@row>45,"NO","VALUE IS 45"))

jhahnlee

@Tomasz Giba, thank you!