Link to home
Start Free TrialLog in
Avatar of Frank .S
Frank .SFlag for Australia

asked on

IF/OR statement & IF/OR/AND statement

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....
Avatar of Benjamin Lu
Benjamin Lu
Flag of China image

You can try this:

1.IFERROR(H6*1,0)*J3*SIGN(E6)

2.IFERROR((H6&C6)*1,0)*J3*SIGN(E6)
Avatar of Frank .S

ASKER

no does not work, because if cell h6= zero or nothing the result must show nothing..
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thankyou experts for your solutions