software

Hi, was wondering if there is a shorter version: have %change equation, that
adds a cummulative of %change for each day, but do not know how to
abbreviate. (must keep original amounts in each column to show direction
up/dn)

(adding separate amounts for each day, for each range selected, such as:
2=(day1 day2),3=(day1 day2 day3)... (thanks)

long verson:
=IF(OR(BS9=quot;quot;,COUNTA(BT9:BX9)=0,MIN(BT9:BX9)=MAX(B T9:BX9)),quot;quot;,
IF(OR($BH$2={quot;quot;,quot;.quot;,2}),(BS9/BT9%-100) (BT9/BU9%-100),IF($BH$2=3,(BS9/BT9%-100) (BT9/BU9%-100) (BU9/BV9%-100),
IF($BH$2=4,(BS9/BT9%-100) (BT9/BU9%-100) (BU9/BV9%-100) (BV9/BW9%-100),
IF($BH$2=5,(BS9/BT9%-100) (BT9/BU9%-100) (BU9/BV9%-100) (BV9/BW9%-100) (BW9/BX9%-100))))))