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

NatetheGreat

Active Member
Joined
Nov 18, 2013
Messages
268
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
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

ukmikeb

Well-known Member
Joined
Jul 10, 2009
Messages
2,757
Hi

I think you are probably missing a closing bracket for the second iteration of this :-
Code:
IF(ROUND(table4[[#this row],[BestAskPrice]],2)-

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

hth
 

NatetheGreat

Active Member
Joined
Nov 18, 2013
Messages
268
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 "!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,521
Messages
5,596,653
Members
414,083
Latest member
Mrsash

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top