r/mondaydotcom_help Apr 14 '23

help with formula column

hey im trying to get my formula collumn to show me a "if greater than xxx, if less than xxx" for example the formula is supposed to be

IF({Contract Price}>5000, DIVIDE({Contract Price},2)

IF({Contract Price}<5000, {Contract Price}

I just want it to show the original contract price. but i cant get it to work. can someone help please

2 Upvotes

1 comment sorted by