Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |