Advertisements
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.
>Solution :
Try this formula
=B2*20% & "-" & B2*30%
For array approach.
=INDEX(IF(LEN(B2:B),B2:B*20% & "-" & B2:B*30%,""))