I need to create a formula that will convert "#N/A" to a specific value.
Specifically, cell A1 contains a VLOOKUP formula in which the value "#N/A" is
displayed when the formula is FALSE (the lookup value is not found), which is
correct.

I need to create another formula that will automatically convert #N/A to
100%, but leave any other values as is. For example, if A1 displays "#N/A"
then I need it to be converted to read 100%. But if A1 displays 70% then I
need it to remain the same.
--
Thanks!

RKEMPER