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
After the first AND in the second row QB says "expecting ," and that there are "extra characters beyond the end of the formula". I assume that means that it doesn't like the AND function and concluded it must be because [Priority] is Text in a Numeric formula.