IF formula works one way and not the other
 

What would be the reason this formulas result is blank (it should be)

=IF(ISNA(S1682),"",IF(OR(ISBLANK(R1682),ISTEXT($R1 682),(R1682=""),(S1682=0)),"",IF(OR(ISBLANK(Q1682) ,(Q1682=""),(Q1682<R1682)),R1682*S1682,Q1682*S1682 )))

And this formula result is #N/A
=IF(OR(ISBLANK(R1683),ISTEXT($R1683),(R1683=""),IS NA(S1683),(S1683=0)),"",IF(OR(ISBLANK(Q1683),(Q168 3=""),(Q1683<R1683)),R1683*S1683,Q1683*S1683))

the only diffeence is =IF(ISNA(S1682),"", versus
=IF(OR(ISBLANK(R1683),ISTEXT($R1683),(R1683=""),IS NA(S1683),

Thank you for the help
Joe

IF formula works one way and not the other
 

Hi!

Based on your question it appears that both S1682 and S1683 contain #N/A.

In the first formula, the first IF(ISNA()..... is an explicit test for a
single condition the result of which is either TRUE or FALSE and the rest of
formula evaluates accordingly.

In the 2nd formula, if S1683 = #N/A then in the OR function:

(S1683=0) evaluates to:

#N/A = 0 = #N/A

The #N/A is then the result of the OR function and that is where the formula
will stop and return #N/A.

What are some of the values used in these formulas?

There seems to be some redundancy with ISBLANK and =""

Biff

"Joe Gieder" wrote in message
...
What would be the reason this formulas result is blank (it should be)

=IF(ISNA(S1682),"",IF(OR(ISBLANK(R1682),ISTEXT($R1 682),(R1682=""),(S1682=0)),"",IF(OR(ISBLANK(Q1682) ,(Q1682=""),(Q1682<R1682)),R1682*S1682,Q1682*S1682 )))

And this formula result is #N/A
=IF(OR(ISBLANK(R1683),ISTEXT($R1683),(R1683=""),IS NA(S1683),(S1683=0)),"",IF(OR(ISBLANK(Q1683),(Q168 3=""),(Q1683<R1683)),R1683*S1683,Q1683*S1683))

the only diffeence is =IF(ISNA(S1682),"", versus
=IF(OR(ISBLANK(R1683),ISTEXT($R1683),(R1683=""),IS NA(S1683),

Thank you for the help
Joe