close
You formula shoule be:
=if(ISNA(Formula),quot;quot;,Formula)
As you wrote it, you were missing the comma before the second formula.
Also, make sure you only have a = at the beginning of the formula.
--
tjquot;Pete Elbertquot; wrote:
gt; Cells have formulas set up in them and will not be used until the cells in
gt; column A have a reference in them. The formula in most all of the cells look
gt; something like this: =VLOOKUP($A6,$A$106:$CB$148,2,FALSE) Someone stated
gt; that =if(ISNA(Formula),quot;quot;Formula) would work, however, everytime I try to
gt; apply it, I must be doing something wrong because I continue to get an error
gt; message on the screen. Can anyone help?
gt;
全站熱搜
留言列表
