Hi,

I am using a formula to capture the top 5 brands.

a
b
c
d
e

However, for some products, it has less than 5 brands. Hence the result will
return
a
b
c
#N/A
#N/A

I want to change #N/A to blank instead. Is there any formula I can use to
convert #N/A to blank.

Currently, I am using =IF(ISNA(B8),"",C8) and it works fine. But ISNA is not
recognised in the Xcelsius software I am using.

Can anyone help?

Thank you