Airtable If-condition yielding NaN values

Other Questions Airtable
1

I’m implementing an If-condition to convert integers based on inputs from another field. While the condition seems to function correctly, I encounter a NaN result when referencing these fields. Below is the formula I’m utilizing. I attempted to wrap the output values in INT() to fix this, but it caused additional issues. Is there something I overlooked?

IF(FIND('A',{Response}),-6,
IF(FIND('B',{Response}),-3,
IF(FIND('C',{Response}),1,
IF(FIND('D',{Response}),3,
IF(FIND('E',{Response}),5,"")))))
2

hey Claire29, try ensuring the field ‘{Response}’ is not actually blank or a text that doesn’t match your conditions. Also, might be worth exploring using VALUE() instead of INT() as it converts text to numbers and might help if your result is being treated as text somewhere. Good luck!