Urgent help needed

Hi, I am new to this excel work and I want to implement the following condition in the excel...but it is not working...can anyone help me ?

if (a2=180) then a2=0,
if (a2>180) & (a2 <=270)=180-a2;
if (a2 > 270)&(a2 <360)=270-a2

waiting for ur replies

Thanks in advance

senthil

Try the following...

=IF(A2=180,0,IF((A2>180)*(A2<=270),180-A2,IF((A2>270)*(A2<360),270-A2,"")))

...or do you mean...

=IF(A2=180,0,IF((A2>180)*(A2<=270),A2-180,IF((A2>270)*(A2<360),A2-270,"")))

Hope this helps!

Hi Thanks a lot and it works
take care
bye
senthil