# Formula is misplaced Paraenthesis

##### Well-known Member
Hello all,

just going a bit mad try to get the expression write, the argument I believe is all correct but I havenot closed it off properly

Any sugesstions

=IF(AND(AG5=\$FE\$53,AH5=\$FE\$54,IF(AND(DropList!\$B\$96=1,AJ5>0),FG5*\$L\$53,IF(DropList!\$B\$96=2,(AM5/(\$B\$28+\$B\$29))*\$L\$54,IF(AND(DropList!\$B\$96=3,AJ5>0),FG5*\$L\$53+(((AM5/(\$B\$28+\$B\$29)/\$L\$61))*\$L\$54),""))))

Thanks Johnny

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Not sure, but try this. You were missing a closing parenthesis at the end of the first AND function.

=IF(AND(AG5=\$FE\$53,AH5=\$FE\$54),IF(AND(DropList!\$B\$96=1,AJ5>0),FG5*\$L\$53,IF(DropList!\$B\$96=2,(AM5/(\$B\$28+\$B\$29))*\$L\$54,IF(AND(DropList!\$B\$96=3,AJ5>0),FG5*\$L\$53+(((AM5/(\$B\$28+\$B\$29)/\$L\$61))*\$L\$54),""))))

Thanks that ogt it to work, now I just have to get it to return a numerical value rather than TRUE/FALSE.

Replies
1
Views
327
Replies
3
Views
90
Replies
1
Views
476
Replies
7
Views
393
Replies
7
Views
188

1,219,811
Messages
6,150,363
Members
450,955
Latest member
rose8693

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back