JamesTroryQrew Assistant Captain7 years agoUse IF text lookup in a numeric formulaHi, 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...Show More
Related ContentNumeric Fields Show Separator After 4 PlacesFormula to lookup value in another related tableRequired Field Default Lookups SSNFormula checkbox using manual checkbox and lookup formulaFormat Numeric Value 2 Decimal Places