View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
 
Posts: 383
Default need FORMULA for different qty of columns, MOD?

hi, have a formula where calculate on a different range of columns, looking
for a way to modify that number, the following using set of 3.

=IF(K9=0,"",((ED9/EE9%)+(EE9/EF9%)+(EF9/EG9%))-300)

is there a way to use MOD.. or other on it to shorten / make adjustable?
thanks.
formula for calculating percent change: fm/to%-100

have following example for adding every other column.

=IF(AC9="","",SUM(--(MOD(COLUMN($AC9:$AK9),2)MOD(COLUMN($AC9),2)),$AC 9:$AK9))