Creating IF formulas with parameters from 2 drop down menus

Hey Room
I am inputting a formula where I have 2 IF's. The first, based on the dropdown menu titled "Age" has dropdowns of '18-34' and '35+'. The answer to the formula will have different parameters if one or the other is chosen.

The second dropdown box then multiplies the result as a percentage.
It's values are:
'0-30%'
'31%-60%'
'61%-75%+'

So if dropdown box #1 selection is "18-34" then the formula is:
B10=(B1*627)+(B1*B6*0.155)*3

If dropdown box #1 selection is "35+" then the formula is:
B10=(B1*627)+(B1*B6*0.155)+(B1*480)*3

The second dropdown box then also comes into play:
If '0-30%' is selected, then the result is B10*0.3
'31%-60%' is selected, then the result is B10*0.6
'61%-75%+' is selected, then the result is B10*0.75

Help!!

Thanks in advance

My apologies... there is no B1

Formulas should read B5

35+ formula isn't 1440*B5... see revision below with added parenthesis... seeing why I need help now!!

Formula when 35+ is selected is:
B10=((B5*627)+(B5*B6*0.155)+(B5*480))*3

Hi KamOnExcel,

copy and past this formula in B10......

=IF(B3="0-30%",IF(B2="<35",(B5*627)+(B5*B6*0.155)*3,(B5*627)+(B5*B6*0.155)+(B5*480)*3)*0.3,IF(B3="31%-60%",IF(B2="<35",(B5*627)+(B5*B6*0.155)*3,(B5*627)+(B5*B6*0.155)+(B5*480)*3)*0.6,IF(B3="61%-75%",IF(B2="<35",(B5*627)+(B5*B6*0.155)*3,(B5*627)+(B5*B6*0.155)+(B5*480)*3)*0.75,"")))

Best of Luck

Thanks mate - what a legend!!

Ive just tested it and it all works except for:
1. No values for 61-75% coming up
2. I think the 35+ calculations are missing the *3 (these figures should always be greater than the 18-34 figures)

Thanks again...

My job tomorrow - sit down and try to unpack what you did and work this mother out!!

under 35 is
((B5*627)+(B5*B6*0.155))*3

over 35 is
((B5*627)+(B5*B6*0.155)+(B5*480))*3

So it is the whole thing x3

To test:
when B5=100 and B6=60000

<35 and 0-30% selected B10 should = 893,430 (297,810x3)

<35 and 31-60% selected B10 should =1,786,860 (595,620x3)

<35 and 61-75% selected B10 should =2,233,575 (744,525x3)

35+ and 0-30% selected B10 should =936,630 (312,210x3)

35+ and 31-60% selected B10 should =1,873,260 (624,420x3)

35+ and 61-75% selected B10 should =2,341,575 (780,525x3)

Really appreciate your efforts with this btw

Humdingaling you are a legend!!