Formula with misplaced Paraenthesis

[cadence]

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

 

[Peter_SSs]

cadence

Best to stick to your original post:
http://www.mrexcel.com/board2/viewtopic.php?t=232683

 

[sbendbuckeye]

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:

=IF(A1>5,IF(A1>10,True2,False2),False1)

=IF(A1>5,       IF(A1>10), True2, False2),      False1)

Good Luck!