IF, error "Expressions yield variant data-type cannot be used to define calculated columns.

Hi everyone,

I've looked through the forums as this seems to be a common error however I haven't seen one that works to give me the right solution.

I have two columns, column A = text data (Yes and No text values)
Column B = number values (numbers 1 to 50)

My formula is: IF(Column A) = "Yes", ([column B]), "n/a" - This is the point where I get the error.

If I use a number instead of "n/a" e.g "0" this works, however I need it to say "n/a" etc due to a lookup table.

I have tried using IF(Column A) = "Yes", Format (column B), ""), "n/a" - again I receive an error.

I am super stuck... :/

Thank you so much in advance

Regards,

P