Tried multiple ways and can't see to figure out the correct way
The below doesn't error however it's not changing the ouput, someone recommended the replace function but i can't figure that one out
if [MRP Controller] in ('F84','F85','F86','F87','F88','F89') then [System LT] = 14 else [System LT] endif
Replace([MRP Controller], 'F84', [System LT], '14')
@joffner you need to write the formula under the field System LT not System LT2
IF [MRP Controller] in ('F84','F85','F86','F87','F88','F89') Then 14, Else [System LT] EndIf
Thank you so much! That did the trick