Can offset be used in this formula?

B

Brad

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)
....
 

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

Similar Threads


Top