Cell offset issue


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
 
Ad

Advertisements

Ad

Advertisements

D

David Biddulph

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top