Multiply a number by a range

[pepsihulk]

Hi,

I am not sure how to proceed with the formula as I want to multiply a number by a percentage range
ie: 65%-85% of 200, I would want the cell to populate with 130-170.

Thanks for your help!

 

[lrobbo314]

How about this.

=A1*0.65&"-"&A1*0.85

 

[Rick Rothstein]

Assuming you need a more general solution in order to handle any arbitrary range, let's assume cell A1 contains the number (200 from your example) and cell B1 contains the percentage range (the 65%-85% from your example), then...

=A1*LEFT(B1,FIND("-",B1)-1)&"-"&A1*MID(B1,FIND("-",B1)+1,15)

 

[Peter_SSs]

Assuming you need a more general solution in order to handle any arbitrary range, let's assume cell A1 contains the number (200 from your example) and cell B1 contains the percentage range (the 65%-85% from your example), then...

=A1*LEFT(B1,FIND("-",B1)-1)&"-"&A1*MID(B1,FIND("-",B1)+1,15)

FWIW that formula could be shortened to

=A1*LEFT(B1,FIND("-",B1)-1)&A1*MID(B1,FIND("-",B1),15)

 

[bosco_yip]

And could be further shortened to :

=IMREAL(B1&"i")*A1&IMAGINARY(B1&"i")*A1

Regards
Bosco

 

[Marcelo Branco]

And could be further shortened to :

=IMREAL(B1&"i")*A1&IMAGINARY(B1&"i")*A1

Cool

M.

 

[Rick Rothstein]

FWIW that formula could be shortened to

=A1*LEFT(B1,FIND("-",B1)-1)&A1*MID(B1,FIND("-",B1),15)

I am surprised I missed that!

 

[Peter_SSs]

=IMREAL(B1&"i")*A1&IMAGINARY(B1&"i")*A1

Good one.

 

[Rick Rothstein]

And could be further shortened to :

=IMREAL(B1&"i")*A1&IMAGINARY(B1&"i")*A1

I really like this one!!!

 

[Marcelo Branco]

I really like this one!!!

Yes, many applications!
For example

	A​	B​	C​	D​	E​
1​	Track​	Grade​		Value​	Result​
2​	1-10​	D​		12​	C​
3​	11-20​	C​		21​	B​
4​	21-30​	B​		8​	D​
5​	31-40​	A​		35​	A​

<tbody>
</tbody>

Usually we need to split the first column in two columns, but now we can use...
E2 copied down
=LOOKUP(D2,IMREAL(A$2:A$5&"i"),B$2:B$5)

M.