Thread: Trying to increase values by a percentage in cells with more than one value

I'm looking for a function or something to increase values by a certain percentage in a cell that contains numerous values. In this spreadsheet. I am focusing on the "D" Column.

I have attached a spreadsheet for example:EXAMPLE.xls

The price and sale-price column are obviously easy to do. In d2 is the following:
"Size"
"2 ft x 3 ft"
"(+155) 3 ft 6 in x 5 ft 6 in"
"(+360) 5 ft x 8 ft"
"(+888) 8 ft x 11 ft"
"(+163) 2 ft 6 in x 8 ft Runner"

I'm looking for a way to increase/decrease the numbers in (+) by a certain percentage.

Originally Posted by scarfo43

I'm looking for a function or something to increase values by a certain percentage in a cell that contains numerous values. In this spreadsheet. I am focusing on the "D" Column.

I have attached a spreadsheet for example:Attachment 135610

The price and sale-price column are obviously easy to do. In d2 is the following:
"Size"
"2 ft x 3 ft"
"(+155) 3 ft 6 in x 5 ft 6 in"
"(+360) 5 ft x 8 ft"
"(+888) 8 ft x 11 ft"
"(+163) 2 ft 6 in x 8 ft Runner"

I'm looking for a way to increase/decrease the numbers in (+) by a certain percentage.

Maybe I am missing something, but in the Example file you attached in column D2, every cell has "SIZE" in the cell, is there supposed to be more? Or as I said, am I missing something?

Sorry. If you click on that cell, it should list the values.

Sorry. If you click on that cell, it should list the values.