NEED HELP ON EXCEL FORMULA

[Brute]

My brain is about to explode.. need help making this formula work.. I am working on an interactive microsoft excel sheet and running into a problem.. I need all of this information to be determined in one cell. It bases its info off of three cells, we will call them cells B2 C2 and D2, answer will be generated in cell E2.

Needs to determine the following.

If value D2 is less than .375 then E2= (((((B2+B2+C2+C2)/4)-D2)*D2)*13.6)

If value D2 equal to / greater than .375 and less than .500 then E2 = (((((B2+B2+C2+C2)/4)-D2)*D2)*13.3)

If value D2 is equal to or greater than .500 then E2 = (((((B2+B2+C2+C2)/4)-D2)*D2)*13.0)

My mind hit its brink at this formula. and it doesnt work, but its on the right track i believe.. i need to figure a way to determine the equal to parts and have it actually use the correct formulas..

Formula I have.. which isnt generating correct numbers after checking with a calculator by hand.

=IF(D2<0.375, (((((B2+B2+C2+C2)/4)-D2)*D2)*13.6), IF(D2>0.500, (((((B2+B2+C2+C2)/4)-D2)*D2)*13), ((((B2+B2+C2+C2)/4)-D2)*D2)*13.3))

Thanks

[Brute]

I have also tried an option with having the values of each equation in cells that will be in a hidden row.. such as..the following column for row N. This is just to take the tedius mathematical part out of the initial formula... now im trying to figure out how to get a formula that will look at the values in row N and place them in the desired 1 cell depending on the value of cell D2.

<.375 This is where equation value would go for N2
=.375 This is where equation value would go for N3
>.375<.500 This is where equation value would go for N4
=.500 This is where equation value would go for N5
>.500 This is where equation value would go for N6


As an example... what im needing is if D2 = .288, then it will place the value in cell N2 into cell E2, if D2 was .987 then it would use the value from cell N6 for the answer to E2.. Hopefully this is making sense... its going to make my life a lot easier once i can figure out what formula will work.

These will all have values in the N column. but using IF statements it is saying i am using to many arguments for one if statement... wont let me nest it

I used the following formula..
=IF(B2<.375,N2,IF(D2=.375,N3),if(.375>D2<.500,N4),if(D2=.500,N5),if(D2>.500,N6))

Also tried IF(B2>.375,N2), OR(IF(B2=.375,N3)), OR(IF(.375<B2<.500,N4)), OR(IF(B2=.500,N5)), OR(IF(B2>.500,N6))) but that didnt result in shit...

What function should I be using? I know its possible.. is there a way to create a table it draws values from? I had a computer based accounting class a few years ago and we did something similar.

Syntax

Any help man?

Thanks

[Spectrus]

=IF(D2>=0.500, (((((2*B2+2*C2)/4)-D2)*D2)*13.0), IF(D2>=0.375, (((((2*B2+2*C2)/4)-D2)*D2)*13.3), (((((2*B2+2*C2)/4)-D2)*D2)*13.6)))

[Brute]

Spectrus

Thanks, looks like it it working. Atleast i wasnt too completel far off. I just didnt know exactly how to write it. Thanks again for the help

[Spectrus]

Spectrus

Thanks, looks like it it working. Atleast i wasnt too completel far off. I just didnt know exactly how to write it. Thanks again for the help

No problem, what's this for? Weird ass formulas.

[Brute]

No problem, what's this for? Weird ass formulas.

Determining the weight of steel depending on the thickness and dimensions