FWIW that formula could be shortened toAssuming 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)
And could be further shortened to :
=IMREAL(B1&"i")*A1&IMAGINARY(B1&"i")*A1
FWIW that formula could be shortened to
=A1*LEFT(B1,FIND("-",B1)-1)&A1*MID(B1,FIND("-",B1),15)
I really like this one!!!And could be further shortened to :
=IMREAL(B1&"i")*A1&IMAGINARY(B1&"i")*A1
I really like this one!!!
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 |