having trouble combining two working formulas

[fingermouse]

Hi, hopefully someone can help with my problem as per the title:

I have 2 working formulas I want to combine with a bit of adjusting:

This formula works (Formula 1)

=IF(AND('Data Area'!BH2="N/A",'Data Area'!AU2="DS"),"Pass","Fail - POMI cannot be N/A")


So does this one: (Formula 2)

=IF(OR(ISBLANK('Data Area'!BH2),ISBLANK('Data Area'!CM2)),"Fail-POPT or POPI cannot be blank",IF('Data Area'!AR2="EWI_Parkhomes",IF(VALUE('Data Area'!CM2)<>VALUE('Data Area'!BH2),"Fail - POMI and POPT for park homes insulation measures must always be equal","Pass"),IF('Data Area'!BH2="N/A","Fail - POMI cannot be N/A",IF(VALUE('Data Area'!CM2)>VALUE('Data Area'!BH2),"Fail - POPT cannot be greater than POMI","Pass"))))

I want to adapt it slightly and replace the red part in formula 2 with formula 1. Like this:


=IF(OR(ISBLANK('Data Area'!BH2),ISBLANK('Data Area'!CM2)),"Fail-POPT or POPI cannot be blank",IF('Data Area'!AR2="EWI_Parkhomes",IF(VALUE('Data Area'!CM2)<>VALUE('Data Area'!BH2),"Fail - POMI and POPT for park homes insulation measures must always be equal","Pass"),IF(AND('Data Area'!BH2="N/A",'Data Area'!AU2="DS"),"Pass","Fail - POMI cannot be N/A",IF(VALUE('Data Area'!CM2)>VALUE('Data Area'!BH2),"Fail - POPT cannot be greater than POMI","Pass"))))

Error message says I have too many arguments. Can someone please provide the correct formula? Many thanks in advance, Cal

 

[fingermouse]

Hi feel free to delete this or my other post, dont know how this happened....