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
no its miffed because the formula is not passing the syntax requirements due to mis-matched brackets
I removed the trailing bracket on the line 2 below, as the IF does not end until the end of the formula.
If(
[Priority]="Normal" AND [Delivery (hours)]>24,[Delivery (hours)]-24,
[Priority]="Rush" AND [Delivery (hours)]>12,[Delivery (hours)]-12)
I removed the trailing bracket on the line 2 below, as the IF does not end until the end of the formula.
If(
[Priority]="Normal" AND [Delivery (hours)]>24,[Delivery (hours)]-24,
[Priority]="Rush" AND [Delivery (hours)]>12,[Delivery (hours)]-12)