Cell offset issue

  • Thread starter Thread starter MGarrison
  • Start date Start date
M

MGarrison

HI,

I am trying to have a row that references cells that are moving 1 down and 1
over. I want to caputure the last number in each column.

Example


A1 4 B1 C1
A2 7 B2 8 C2
A3 9 B3 4 C3 15
A4 B4 6 C4 10
C5 12

I am trying to create a row that will read
A6 9 B6 6 C6 12

NOT

A6 9 B6 4 C6 15

Thanks
 
1E100 means 10 to the power of 100, or 1 followed by 100 zeroes, in other
words, a large number.

More generally, 1.2345E67 means 1.2345 multiplied by (10 to the power of 67)
or in Excel terms =1.2345*10^67
 
Back
Top