hi

I have a excel sheet

Column K Column L Column M

A or B or C
drop down list

there will be values on Column K,

Column L is a drop down list which ever i select either A ,B or C i
have a Formula like this on Column M

=IF((L9="A"),-1*K9,IF((L9=""),"",IF((L9="B"),K9*F9,IF((L9="C"),0 *K9))))

I have more than 400 Rows this is taking a lot of time to calculate the
formula ...is there any best way to do this ? any VBA code ?

Thanx in advance

Regards
Jay