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

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.

enter image description here

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.

>Solution :

Try this formula

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

For array approach.

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

enter image description here

Leave a Reply