June7 AWF VIP Local time Yesterday, 20:05 Joined Mar 9, 2014 Messages 6,129 Jun 22, 2024 #21 Simplify expression as Gasman showed. Or this one: =[amount] * IIf([duty_type]='Adjunct', 0.33, 1)
P plog Banishment Pending Local time Yesterday, 23:05 Joined May 11, 2011 Messages 12,060 Jun 22, 2024 #22 Why do you even need to multiply by one? Click to expand... Just to be safe, I'd also multiply it by itself, take the absolute value of that square root, add 0 to it and raise everything to the power of 1.
Why do you even need to multiply by one? Click to expand... Just to be safe, I'd also multiply it by itself, take the absolute value of that square root, add 0 to it and raise everything to the power of 1.