multiplying cell value with text in it

**bobbied** · 03-22-2010, 05:20 PM

I would like to create a formula that would do the following:

Y= 1oz and 1oz is the equivelant to 48 parts

1y16*4=5y16

So the formula would understand to multiply the 1y 4 times to get 4y and the 16 4 times to get 64 and then take the 64 divide by 48 leaving you with 1.333333, and then add the extra oz and round up to 16 parts of the oz. giving you the answer of 5y16.

I hope this makes sense.

Thanks,

**darkyam** · 03-22-2010, 05:23 PM

Welcome to the forum. Please take a moment to read the rules and then amend your thread title in accordance with rule 1. Thanks.

**darkyam** · 03-22-2010, 05:48 PM

I would suggest a thread title more like: "multiplying cell value with text in it". The reason we're sticklers here is that half the purpose of the forum is to help others who may have a similar problem to yours, so they can search without having to post their own question.

Anyway, if 1y16 is in A1 and 4 is in B1, C1 can be =LEFT(A1,FIND("y",A1)-1)*B1+INT(RIGHT(A1,LEN(A1)-FIND("y",A1))*B1/48)&"y"&MOD(RIGHT(A1,LEN(A1)-FIND("y",A1))*B1,48)