For a start these are the same, greater than 0 & greater than 2000 (same thing). Plus aren't you only allowed a certain number of conditions (7 or 9 I think) does this exceed that limit (count the IF's).
=IF(AND(BQ2="3A",BT2="Offshore",(CB2-CA2)>2000),CB2-CA2,(IF(AND(BQ2="3A",BT2="Offshore",(CB2-CA2)>=0),2000
This is mid formula and has a true and a false result, I would guess this is your problem.
IF(AND(BQ2="4B",BT2="Offshore",(CB2-CA2)>0,BZ2="A",(CB2-CA2)>CA2*7%),CB2-CA2,CA*7%
I gave up after this, I think that's enough to get you going
Bookmarks