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(E
2_basically if h6 & C6= either nothing or zero qty then do nothing otherwise....
1_basically if h6 = either nothing or zero qty then do nothing otherwise....
=IF(H6="","",(H6*J3*SIGN(E
2_basically if h6 & C6= either nothing or zero qty then do nothing otherwise....
Microsoft ExcelMicrosoft Office
Last Comment
Frank .S
ASKER
no does not work, because if cell h6= zero or nothing the result must show nothing..
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thankyou experts for your solutions
1.IFERROR(H6*1,0)*J3*SIGN(
2.IFERROR((H6&C6)*1,0)*J3*