formulae problem:HELP

hello there, i have jst started a new I.T job and need some help with excel,heres my problem, if cell A = 5014 then l - m. under a lot of pressure here can somone please help

Assume your first data point is in cell A1. I also assume your "l - m"
would refer to cells L1 and M1.

In the cell where you want the result, type: =if(A1=5014, L1-M1).

You can copy this down to other cells as needed.


"stevenmorrison"
<stevenmorrison.1tluyt_1123772727.0956@excelforum-nospam.com> wrote in
message news:stevenmorrison.1tluyt_1123772727.0956@excelforum-nospam.com...
>
> hello there, i have jst started a new I.T job and need some help with
> excel,heres my problem, if cell A = 5014 then l - m. under a lot of
> pressure here can somone please help
>
>
> --
> stevenmorrison
> ------------------------------------------------------------------------
> stevenmorrison's Profile:
> http://www.excelforum.com/member.php...o&userid=26188
> View this thread: http://www.excelforum.com/showthread...hreadid=394950
>