We help IT Professionals succeed at work.

IF/OR statement & IF/OR/AND statement

Frank .S
Frank .S asked
on
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....
Comment
Watch Question

View Solutions Only

Benjamin LuSAP/ERP Data Processing
CERTIFIED EXPERT

Commented:
You can try this:

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

2.IFERROR((H6&C6)*1,0)*J3*SIGN(E6)
Frank .SBuilding Estimator

Author

Commented:
no does not work, because if cell h6= zero or nothing the result must show nothing..
Mechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013
Commented:
I suggest that we start with a good definition of what each cell is supposed to contain. We can then write formulas to calculate those values.

Assumptions:
C6 is number of repeating patterns
D6 and F6 are the length and width (in meters) of each pattern
E6 & G6 are the number of tiles (rounded up) necessary to span the length and width of the pattern
H6 is the number of tiles needed for the area being tiled, including repeats
I6 is the area (square meters) of the repeating pattern, including repeats
J6 is the area (square meters) of the tiles used, including repeats

If my assumptions are correct, the attached workbook implements them.
tiles-wall-floor_1.xlsx
Benjamin LuSAP/ERP Data Processing
CERTIFIED EXPERT
Commented:
You can try:nothing=""

1.IF(ISNUMBER(IF(H6=0,"",H6)),H6*J3*SIGN(E6),"")
=IF(ISNUMBER(IF((H6&C6)*1=0,"",(H6&C6)*1)),H6*J3*SIGN(E6),"")
Frank .SBuilding Estimator

Author

Commented:
thankyou experts for your solutions