XL FORMULA   

I want help in this formula:

if i write in cell A1 = p,

If(A1=P, then the value should be Written in B1=1
if(B2=L, then Vale should be written in B2=1
If(C2=A, then value should be wriiten in D2=-1

date: Fri, 8 Aug 2008 02:10:01 -0700   author:   Fani