خطای n/a در اکسل
#N/A
the
N/A error value is short for not available , which means that the formula couldn’t return
a legitimate result. You usually see
#N/A when you use an inappropriate argument or if you
omit a required argument in a function.
HLOOKUP() and VLOOKUP() , for example, return #N/A
if the lookup value is smaller than the first value in the lookup range.
To solve the problem, first check the formula’s input cells to see if any of them are displaying
the
#N/A error. If so, that’s why your formula is returning the same error; the problem
actually lies in the input cell. When you’ve found where the error originates, examine the
formula’s operands to look for inappropriate data types. In particular, check the arguments
used in each function to ensure that they make sense for the function and that no required
arguments are missing.
مدیریت وبلاگ:آقای حسن احمدی دانشجوی کارشناسی ارشد مهندسی صنایع