Can offset be used in this formula?
 

Can the offset be used in the below formula for the information in column "K"?

In column L have the the following formula's
L46 =MAX($I46*1000-$K$46*$J46,0)
L47 =MAX($I47*1000-$K$46*$J47,0)
....
L99 =MAX($I99*1000-$K$46*$J99,0)

What I'd like to do is to copy the fomula into columns M, N, O, ...

M47 =MAX($I47*1000-$K$47*$J47,0)
M48 =MAX($I48*1000-$K$47*$J48,0)
M49 =MAX($I49*1000-$K$47*$J49,0)
....

N48 =MAX($I48*1000-$K$48*$J48,0)
N49 =MAX($I49*1000-$K$48*$J49,0)
....

O50 =MAX($I50*1000-$K$50*$J50,0)
O51 =MAX($I51*1000-$K$50*$J51,0)
....

Can offset be used in this formula?
 

How about

N48: =MAX($I48*1000-OFFSET($K$47,COLUMN()-COLUMN(M1),0)*$J48,0)

--

HTH

Bob

"Brad" wrote in message
...
Can the offset be used in the below formula for the information in column
"K"?

In column L have the the following formula's
L46 =MAX($I46*1000-$K$46*$J46,0)
L47 =MAX($I47*1000-$K$46*$J47,0)
...
L99 =MAX($I99*1000-$K$46*$J99,0)

What I'd like to do is to copy the fomula into columns M, N, O, ...

M47 =MAX($I47*1000-$K$47*$J47,0)
M48 =MAX($I48*1000-$K$47*$J48,0)
M49 =MAX($I49*1000-$K$47*$J49,0)
...

N48 =MAX($I48*1000-$K$48*$J48,0)
N49 =MAX($I49*1000-$K$48*$J49,0)
...

O50 =MAX($I50*1000-$K$50*$J50,0)
O51 =MAX($I51*1000-$K$50*$J51,0)
...

Can offset be used in this formula?
 

Thank you



"Bob Phillips" wrote:

How about

N48: =MAX($I48*1000-OFFSET($K$47,COLUMN()-COLUMN(M1),0)*$J48,0)

--

HTH

Bob

"Brad" wrote in message
...
Can the offset be used in the below formula for the information in column
"K"?

In column L have the the following formula's
L46 =MAX($I46*1000-$K$46*$J46,0)
L47 =MAX($I47*1000-$K$46*$J47,0)
...
L99 =MAX($I99*1000-$K$46*$J99,0)

What I'd like to do is to copy the fomula into columns M, N, O, ...

M47 =MAX($I47*1000-$K$47*$J47,0)
M48 =MAX($I48*1000-$K$47*$J48,0)
M49 =MAX($I49*1000-$K$47*$J49,0)
...

N48 =MAX($I48*1000-$K$48*$J48,0)
N49 =MAX($I49*1000-$K$48*$J49,0)
...

O50 =MAX($I50*1000-$K$50*$J50,0)
O51 =MAX($I51*1000-$K$50*$J51,0)
...




.