Formula Needed With Word Removal Instruction

Hi Guys

Ive Got An Awkward One Here

In Cell C29 I Have To Input A Quantity Of What I Want
In Cell D29 I Have A Cell Telling Me What They Come In

Ie Box Of 24
Pack Of 50
Each

In Cell L29 Is A Price Per Each Unit ( Singularly )

What Im Hoping Is A Formula So That It Will Work Out The Total For Me Of Any Scenario

So If I Want 2 Boxes ( C29 ) Where They Come In Boxes Of 24 ( D29 ) And The Unit Price Is ( £1.00 )

It Will Read Cell L29 Then Multiply It By D29 And Then By C29

But Obviously It Will Only Be Able To Read The Number Part Of D29

How Is This Possible?

Many Thanks In Advance

If the word part always consists of a one-word container and "of", you can use

Please Login or Register  to view this content.

Cheers Darkyam

Thats Great

How Do I Get The Cell To Remain Empty If There Is Nothing In The Cell As Its Asking For Value

Please Login or Register  to view this content.

cheers darkyam

youre a star

darkyam
the only thing wrong with it is that it doesnt work under the each

ie if it comes in each it still requests value

i could put pack of 1 or box of 1 if its easier to do i suppose but was hoping to keep it as each

Please Login or Register  to view this content.

Can you simplify it, and list list the multiple that the parts can come in?

If not, you could make it a drop down where they select the type they want (say each, pack of 50, box of 24, etc,...), then have the next cell find the corresponding multiplier. Here's some ways you could do the this option:
http://www.excelforum.com/showthread.php?t=644544

Perfect

Thanks Very Much