# Formula with 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),""))))

These are what the cells possible values are, if its of any help.
AG5 = symbol W
FE53 = symbol W
AH5 = symbol Y
FE54 = symbol Y
Droplist!B96 = 1,2 or 3
AJ5 = 1
FG5 =100 number
L53= 17% (tax)
B28 + B29 = number 1-100
AM5 = 200 number
L61 = .5 Exchange rate
L53= 14% (tax)

thanks of solutions on the brain teaser

Thanks Johnny

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Hello,

I would suggest working it a step at a time from the inside out so that you can verify the individual steps. Also, in edit mode you can space things out with extra spaces to help ensure things are grouped as you think:
Code:
``=IF(A1>5,IF(A1>10,True2,False2),False1)``
Code:
``=IF(A1>5,       IF(A1>10), True2, False2),      False1)``
Good Luck!

Replies
2
Views
316
Replies
4
Views
764
Replies
3
Views
274
Replies
6
Views
457
Replies
15
Views
502

1,211,696
Messages
6,103,354
Members
447,861
Latest member
LllopezXC

### 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