the first part is working and the second is not working

Can you please check this formula if is correct ?: IF(
OR(
[Service] = "Busi P",
[Service] = "Busi N-P"
),
IF(
OR(
ABS([Percentage Weight Difference]) > 0.04,
ABS([Percentage Weight Difference]) < -0.04
),
"Postponed",
"Proceed"
),
IF(
OR(
[Service] = "BM P",
[Service] = "BM N-P",
[Service] = "Publ P",
[Service] = "Publ N-P"
),
IF(
OR(
ABS([Percentage Weight Difference]) > 0.05,
ABS([Percentage Weight Difference]) < -0.05
),
"Postponed",
"Proceed"
),
IF(
OR(
[Service] = "Busi P",
[Service] = "Busi N-P",
[Service] = "BM P",
[Service] = "BM N-P",
[Service] = "Publ P",
[Service] = "Publ N-P"
),
IF(
OR(
ABS([Percentage Items Difference]) > 0.03,
ABS([Percentage Items Difference]) < -0.03,
ABS([F Discrepancy Items]) > 10,
ABS([C Different]) > 10,
ABS([ PPI]) > 50
),
"Postponed",
"Proceed"
),
"Proceed"
)
)
)

0 1 34
1 REPLY 1

You could write it little bit easier with something like..

IF(
OR(
  AND(
    IN([Service],{"Busi P","Busi N-P"}),
    ABS([Percentage Weight Difference]) > 0.04
  ),
  AND(
    IN([Service],{"BM P","BM N-P","Publ P","Publ N-P"}),
    ABS([Percentage Weight Difference]) > 0.05
  ),
  AND(
    IN([Service],{"Busi P","Busi N-P","BM P","BM N-P","Publ P","Publ N-P"}),
    OR(
      ABS([Percentage Items Difference]) > 0.03,
      ABS([F Discrepancy Items]) > 10,
      ABS([C Different]) > 10,
      ABS([PPI]) > 50
      )
    )
  ),
"Postponed",
"Proceed"
)

To understand why the 2nd part is not working, you should elaborate it a little.. like what are you values and why do you think it doesn't work properly.

Top Labels in this Space