I want to show a range of in Cell using another column but not exactly named ranges

Question

So basically, what I am trying to do is in column C is, I want show that it is 20% of B - 30% of B.

For Example, take C2,

I want to show it as "100 - 150".

PS: When I say "100 - 500", I don't mean 100 minus 500, I want to show it as a range.

Answer 1

Try this formula

=B2*20% & "-" & B2*30%

For array approach.

=INDEX(IF(LEN(B2:B),B2:B*20% & "-" & B2:B*30%,""))