#### Darth yoda

##### New Member

- Joined
- Feb 27, 2013

- Messages
- 35

Need a bit of help in Excel 2007. I'm a machinist and often have to make stack of block to create angles. I can get the sin function to spit out a proper stack height but I want to give it a list of sizes to use with no two sizes being repeated.

The formula is : =SIN(E2*PI()/180)*E3

E2 is the angle wanted, such as 30 degrees and E3 is the length of the sine bar (usually 10,5, or 3 inches).

You enter the degrees and it spits out a number, in this case .500, then it is multiplied by the length of the sine bar (X3 in my case). The stack height is 1.500 inches. Easy enough...... right?

The hard part is 32 degrees and 3 inch bar. The correct answer is 1.5897 rounded to 4 places.

If I have a set of 36 blocks. Each block a different size. What I need to do is convert the right most number to zero using my .1007 block and remove it from the list so it cant be used again.

So now my Number is 1.4890 (1.5897-0.1007). The 9 is the next number so I use my .109 block for a remainder of 1.3800. The next blocks are .180, .200, and finally 1.000. each time the used block needs to be removed from the list.My guess would be a vlookup type funtion but have no idea how to remove blocks from the list.

Any help would be greatly appreciated.

Thanks in advance,

Darth