Complex Nesteed IFs - garbage after expression

[#1]

Hello,

I need to have this 3 satements to define the colour of my bares, but I'm getting the fllowing error "garbage after expression"

My code is the following:

IF(A = 0,(IF(FIELD=1, RGB(34, 156, 228),IF(FIELD=2, RGB(0, 0, 0), IF(FIELD=3, RGB(34, 156, 228),IF(FIELD=4, RGB(0, 0, 0),IF(FIELD=5, RGB(34, 156, 228),IF(FIELD=6, RGB(0, 0, 0)))))))))

//

=IF(A= 1,

  only({<FIELD={1}>} RGB(120,120,120)),

  IF(A=2,

  only({<FIELD={2)>} RGB(120,120,120)),

  IF(A= 3,

  only({<FIELD={3} RGB(120,120,120))));

  =IF(A2=4,

  only({<FIELD={4}>} RGB(120,120,120)),

  IF(A2=5,

  only({<FIELD={"<=5"}>} RGB(120,120,120)),

  IF(A2=6,

      only({<FIELD={"<=6)"}>} RGB(120,120,120))

  )));

Can anybody help me?

[sunny_talwar]

What are you expecting to do?

[#3]

First Silcer (0,1,2,3):
    - Value 0 selected - All the colours have the colour default:

IF(A = 0,

IF(Match(FIELD, 1, 3, 5), RGB(34, 156, 228),

IF(Match(FIELD, 2, 4, 6), RGB(0, 0, 0))))

    - Value 1 selected:
          Only bares from local 1 change to a new colour (green for example).

- Value 2 selected:

          Only bares from local 1 and 2 change to a new colour (green for example).

- Value 3 selected:

          Only bares from local 1 and 2  and 3 change to a new colour (green for example).

Second Slicer (4,5,6):

- Value 4 selected:
          Only bares from local 4 change to a new colour (green for example).

- Value 5 selected:

          Only bares from local 4 and 5 change to a new colour (green for example).

- Value 6 selected:

          Only bares from local 4 and 5  and 6 change to a new colour (green for example).

I need to create two slicers because customers wants a slicer with 2 points, so I create this tricky solution to provide it two selectores in slicers.

Thanks!