Complex Multi-Nestled If Formula Not Working (formula contains an error)

[NatetheGreat]

HI,

My Complex (at least it is to me ) formula is not working. Excel is saying the formula contains an error, but I cannot see one


This formula


=IF(Table4[[#This Row],[#bs]]="Ak",IF(Table4[[#this row],[Type]]="ent",IF(ROUND(table4[[#this row],[BestAskPrice]],2)-
ROUND(Table4[[#This Row],[Price]],2)<.02,table4[[#this row],[Enter Ask]]+t3,t3),IF(ROUND(Table4[[#thisrow],[BestAskPrice]],
2-ROUND(Table4[[#This Row],[Price]],2)<.02,table4[[#this row],[Delete Ask]]+t3,t3),t3)


All the data is there... someI imagine that there is a parentheses or misplaced comma or clause.

Thanks

Nate

 

[pleeseemailme]

Does adding two ")" closing parenthesis at the very end solve the problem?

 

[ukmikeb]

Hi

I think you are probably missing a closing bracket for the second iteration of this :-

IF(ROUND(table4[[#this row],[BestAskPrice]],2)-

and possibly closing brackets at the end as stated by @pleeseemailme.

hth

 

[NatetheGreat]

Does adding two ")" closing parenthesis at the very end solve the problem?

I actually have worked it out by fiddling with the clauses within. There was a few typos when I was copying from my workbook as well i.e. #bs in the first tableref is a typo and not possible.

Thanks for trying though "!