Formula IF greater than/lower than include text

Platform discussions
, ,
1

Hi,
Can I add a formula to write text based on number value? For example, if number is less than 50, insert text “Risk” but if number is more than 50, insert text “Low risk”.

2

Hi Hayley,

Sure. Try:

IF({Numbers}<50,"Risk","Low Risk")

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.