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

[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="bgcolor: #DCE6F1"]

A​

[/TD]
[TD="bgcolor: #DCE6F1"]

B​

[/TD]
[TD="bgcolor: #DCE6F1"]

C​

[/TD]
[TD="bgcolor: #DCE6F1"]

D​

[/TD]
[TD="bgcolor: #DCE6F1"]

E​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

1​

[/TD]
[TD]

Track​

[/TD]
[TD]

Grade​

[/TD]
[TD][/TD]
[TD]

Value​

[/TD]
[TD]

Result​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

2​

[/TD]
[TD]

1-10​

[/TD]
[TD]

D​

[/TD]
[TD][/TD]
[TD]

12​

[/TD]
[TD]

C​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

3​

[/TD]
[TD]

11-20​

[/TD]
[TD]

C​

[/TD]
[TD][/TD]
[TD]

21​

[/TD]
[TD]

B​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

4​

[/TD]
[TD]

21-30​

[/TD]
[TD]

B​

[/TD]
[TD][/TD]
[TD]

8​

[/TD]
[TD]

D​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

5​

[/TD]
[TD]

31-40​

[/TD]
[TD]

A​

[/TD]
[TD][/TD]
[TD]

35​

[/TD]
[TD]

A​

[/TD]
[/TR]
</tbody>[/TABLE]


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.