formulae problem:HELP

[stevenmorrison]

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

 

[Lewis Clark]

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"