Help with nesting over 7 functions

[dr1Zz]

I'm looking to nest over 7 functions in Excel. I am trying to get specific names of counties to represent there tax amounts to spit out totals on services. Below is the current nesting, i need to add 1 more entry but, excel does now allow it. IS there any easy workaround for this?


=ROUND( IF(C4="Long Island", F4*0.0875, IF(C4="New Jersey",F4*0.06, IF(C4="N.Roch/Yonk", F4*0.085, IF(C4="NYC", F4*0.08625, IF(C4="Rockland", F4*0.08125, IF(C4="Westchester", F4*0.075, IF(C4="White Plains", F4*0.08, 0))))))),2)

I'd like to add this entry as well IF(C4="Suffolk", F4*0.0875

Any and all help is greatly Appreciated..

 

[billdoor]

this may sound simple, but can't you make a table in another part of spreadsheet, putting in all the place names and values, and then use the following

=(vlookup(c4,Table,2,false))*f4

 

[dr1Zz]

I guess, the sad part is i am completely new to Excel... is there tutorial or something on how to use the Vlookup's? and set everything up?
Thx for the quick response

 

[billdoor]

no need to, set table as followed

State in first column, Tax in second

In vlookup formula, replace table with cell references including column header.

it will give you a breakdown of how to use if you type in =vlookup() in cell and then press the = button in the toolbar (to the left )

 

[Pekkavee]

You can find tutorial in Excel

Press F1 and search for vlookup.

Pekka

 

[dr1Zz]

no need to, set table as followed

State in first column, Tax in second

In vlookup formula, replace table with cell references including column header.

it will give you a breakdown of how to use if you type in =vlookup() in cell and then press the = button in the toolbar (to the left )

Any Chance of a sample line?
thx for thr great help

 

[billdoor]

table is h1:I10 this gives you 9 rows for data

=(vlookup(c4,H1:I10,2,false))*f4

where c4 is where you type in state
and f4 is figure you require to tax

if still stuck email me

 

[dr1Zz]

Just wanted to say "billdoor" is the man. Solved my Problem in minutes.
Thx Again Bro, saved A LOT of time for me =)