hi experts, how can i add an IF/OR statement & a IF/OR/AND to the following formula below?
1_basically if h6 = either nothing or zero qty then do nothing otherwise....
=IF(H6="","",(H6*J3*SIGN(E6)))
2_basically if h6 & C6= either nothing or zero qty then do nothing otherwise....
1.IFERROR(H6*1,0)*J3*SIGN(
2.IFERROR((H6&C6)*1,0)*J3*