I have work sheet like mentioned below, i am trying to increase or decrease
in load column, in the rest of the column it has to allocate the figures and
match with the load column. I am trying to write a formula, can anyone please
help me in this.

GBR RSL WDJ MAN ALK BRK LOAD
250 50 0 110 0 380 790
240 50 0 90 0 360 740
240 40 0 80 0 340 700
240 40 0 80 0 340 700
230 40 0 70 0 330 670
240 40 0 80 0 350 710

G3: =G2-B3

and copy down.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"srpavar" <(E-Mail Removed)> wrote in message
news:FEB92871-2236-45F4-A379-(E-Mail Removed)...
>I have work sheet like mentioned below, i am trying to increase or decrease
> in load column, in the rest of the column it has to allocate the figures
> and
> match with the load column. I am trying to write a formula, can anyone
> please
> help me in this.
>
> GBR RSL WDJ MAN ALK BRK LOAD
> 250 50 0 110 0 380 790
> 240 50 0 90 0 360 740
> 240 40 0 80 0 340 700
> 240 40 0 80 0 340 700
> 230 40 0 70 0 330 670
> 240 40 0 80 0 350 710
>
>