Help for my rate calculator - How to connect two IF formulas?

[KCALDERON5894]

Hello Excel Gurus out there. I am trying to calculate premiums and I have the option of 7 Limits and 5 deductible options. I am trying to connect the IF section that correctly calculates the premium now but I want to add options for deductibles (C6). I tried =IF(C5>=1000000,LOOKUP(C5,{1000000,1500000,2000000,2500000,3000000,4000000,5000000},C15:C21),0))AND, IF(C6>=1000,LOOKUP(C6,{1000,2500,5000,10000,15000},C15:G15),0) but it tells me I have an error… Help please!
[TABLE="width: 565"]
<tbody>[TR]
[TD][/TD]
[TD]C12
[/TD]
[TD]C13
[/TD]
[TD]C14
[/TD]
[TD]C15
[/TD]
[TD]C16
[/TD]
[TD]C17
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Deductibles
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C14
[/TD]
[TD]Limits
[/TD]
[TD]$1,000
[/TD]
[TD]$2,500
[/TD]
[TD]$5,000
[/TD]
[TD]$10,000
[/TD]
[TD]$15,000
[/TD]
[/TR]
[TR]
[TD]C15
[/TD]
[TD]$1,000,000
[/TD]
[TD]$1,100
[/TD]
[TD]$1,045
[/TD]
[TD]$957
[/TD]
[TD]$935
[/TD]
[TD]$880
[/TD]
[/TR]
[TR]
[TD]C16
[/TD]
[TD]$1,500,000
[/TD]
[TD]$1,265
[/TD]
[TD]$1,202
[/TD]
[TD]$1,122
[/TD]
[TD]$1,075
[/TD]
[TD]$1,012
[/TD]
[/TR]
[TR]
[TD]C17
[/TD]
[TD]$2,000,000
[/TD]
[TD]$1,430
[/TD]
[TD]$1,359
[/TD]
[TD]$1,266
[/TD]
[TD]$1,216
[/TD]
[TD]$1,144
[/TD]
[/TR]
[TR]
[TD]C18
[/TD]
[TD]$2,500,000
[/TD]
[TD]$1,640
[/TD]
[TD]$1,558
[/TD]
[TD]$1,455
[/TD]
[TD]$1,394
[/TD]
[TD]$1,312
[/TD]
[/TR]
[TR]
[TD]C19
[/TD]
[TD]$3,000,000
[/TD]
[TD]$1,850
[/TD]
[TD]$1,758
[/TD]
[TD]$1,625
[/TD]
[TD]$1,573
[/TD]
[TD]$1,480
[/TD]
[/TR]
[TR]
[TD]C20
[/TD]
[TD]$4,000,000
[/TD]
[TD]$2,250
[/TD]
[TD]$2,138
[/TD]
[TD]$1,985
[/TD]
[TD]$1,913
[/TD]
[TD]$1,800
[/TD]
[/TR]
[TR]
[TD]C21
[/TD]
[TD]$5,000,000
[/TD]
[TD]$2,650
[/TD]
[TD]$2,518
[/TD]
[TD]$2,650
[/TD]
[TD]$2,253
[/TD]
[TD]$2,120
[/TD]
[/TR]
</tbody>[/TABLE]

 

[AlexaS]

First things first, I don't know if this fixes it but in your formula you have an extra parenthesis: =IF(C5>=1000000,LOOKUP(C5,{1000000,1500000,2000000,2500000,3000000,4000000,5000000},C15:C21),0))AND, IF(C6>=1000,LOOKUP(C6,{1000,2500,5000,10000,15000},C15:G15),0)

Also - your diagram of the spreadsheet is a little confusing. What does your data look like and what should this formula be returning? Can you give an example? What exactly are your row/column labels (the C12-C17 and C14-C21)?