Use IF text lookup in a numeric formula
Hi, I have a numeric formula that calculates the amount of hours that have passed if a date/time exceeds 24 hours. If([Delivery (hours)]>24,[Delivery (hours)]-24) I would like to add the cond...
Forum Discussion
I figured it out. It's that "AND" is capitalized. I made them lowercase and now it lets me save the formula without errors.
I had no idea that this could cause conflict. Good to know.
I had no idea that this could cause conflict. Good to know.
I've definitely noticed that the syntax highlighting stuff doesn't always indicate an actual error, and that you can still save and have a working formula. It can be pretty misleading.