missing N function

R,

Numbers doesn't support the N function, and what you might do about it depends on what type of data is in K12 and L13. While the expression "=IF(N(K12),L13/K12,0)" may have produced an acceptable result in Excel, "N(K12)" doesn't make much sense as the comparison argument in an IF statement, and therefore I don't think much of the technique. I would change the expression just for clarity if for no other reason.

Jerry

May you describe what the N function is supposed to do ?

Yvan KOENIG (VALLAURIS, France) mercredi 7 octobre 2009 09:48:43

N is a conversion formula. It turns TRUE into 1, FALSE into 0, dates into "serial numbers", numbers into numbers and errors into errors (i.e., no conversion), and everything else into 0.

Thanks.

So this formula seems to mimic it:

=IF(B=TRUE,1,IF(B=FALSE,0,IF(NOT(ISERROR(B*1)),B,IF(NOT(ISERROR(DAY(B))),DATEDIF (DATE(1904,1,1),B,"D"),IF(ISERROR(B),B,0)))))

Yvan KOENIG (VALLAURIS, France) mercredi 7 octobre 2009 11:46:38

Close but not exact. If B is an error (such as "numbers cannot be divided by zero") the N function will return the same error. The IF statement will return "B2 is an error", not "numbers cannot be divided by zero". I doubt anyone really wants to go that far anyway. Depending on what is in the OP's cell K12, N may not be required at all or may just require the completion of the condition statement. I'm with Jerry on the opinion that N(K12) is not a proper condition, it is not a TRUE or FALSE.