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

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.

CodePudding user response：

Try this formula

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

For array approach.

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

CodePudding user response：

Array

Paste this on C2 no need to drag down take a look at this

Cell

Paste this on C2 in a single cell
=CONCAT(CONCAT(A2*20%," - "),A2*30%)
))