This formula uses more levels of nesting than you can use in the current file format

I have a really long nested formula, is there anyway I can make it shorter to work?

`=IF(OR(AND(BR2="Closed",BS2="Not Started",BS2="Open",BT2="Not Started",BT2="Open",BU2="Not Started",BU2="Open"),"25%",IF(OR(AND(BR2="Closed",BS2="Closed",BT2="Not Started",BT2="Open",BU2="Not Started",BU2="Open"),"50%",IF(OR(AND(BR2="Closed",BS2="Closed",BT2="Closed",BU2="Not Started",BU2="Open"),"75%",IF(OR(AND(BR2="Closed",BS2="Closed",BT2="Closed",BU2="Closed"),"100%","0%"))))`

`OR(AND(`

in each part, but closing brackets are not matching (only one`)`

exists for each of them, that makes much more difficult to understand your formula. Please fix it. Also please post some sample output with desired results to help us understand your situation – Máté Juhász Sep 12 at 7:54`... AND( ..., BS2="Not Started",BS2="Open", ...)`

. How does the cell value can be equal to 2 different values at the same time? – Akina Sep 12 at 8:27`=SWITCH(1+(BR2="Closed")+(BS2="Closed")+(BT2="Closed")+(BU2="Closed"),"0%","25%","50%","75%","100%")`

. – Akina Sep 12 at 8:29