I made a drop down list in a worksheet to convert between ounces, kilograms, grams and pounds. When scroll down to kilogram I get A #NA error. Here is the formula I used. =CONVERT(H18,K17,N17) If I scroll between the other units they all convert fine. But if I use Kilograms I get the error.
Solved by O. C. in 24 mins