formulae problem:HELP

  • Thread starter Thread starter stevenmorrison
  • Start date Start date
S

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
 
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"
 
Back
Top