can someone please help

[stevenmorrison]

im not the best at my formulaes when it comes to excel, im on a tria
period for a I.T company and ive been asked to come up with a formule.

heres my problem, 2 different values in collum a,5014 & 5015, now basi
formula is
if cell A = 5014. L-M.

so the L & M rows which have 5014 in thier row are used in thi
calculation, can someone please help me.

as im under a lot of pressure

 

[Ian]

Have a look at the help in Excel and you'd find this very straightforward.

Any IF statement needs 2 outcomes, effectively IF & IF NOT.

=IF(A1=5014,L1-M1,"")

This will give a blank cell if A1<>5014