G
Guest
What would be the reason this formulas result is blank (it should be)
=IF(ISNA(S1682),"",IF(OR(ISBLANK(R1682),ISTEXT($R1682),(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=""),ISNA(S1683),(S1683=0)),"",IF(OR(ISBLANK(Q1683),(Q1683=""),(Q1683<R1683)),R1683*S1683,Q1683*S1683))
the only diffeence is =IF(ISNA(S1682),"", versus
=IF(OR(ISBLANK(R1683),ISTEXT($R1683),(R1683=""),ISNA(S1683),
Thank you for the help
Joe
=IF(ISNA(S1682),"",IF(OR(ISBLANK(R1682),ISTEXT($R1682),(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=""),ISNA(S1683),(S1683=0)),"",IF(OR(ISBLANK(Q1683),(Q1683=""),(Q1683<R1683)),R1683*S1683,Q1683*S1683))
the only diffeence is =IF(ISNA(S1682),"", versus
=IF(OR(ISBLANK(R1683),ISTEXT($R1683),(R1683=""),ISNA(S1683),
Thank you for the help
Joe