I HAVE TWO SHEETS:

1. SCHEDULE
2. EVALUATION

IN THE SHEET SCHEDULE I HAVE TWO COULUMNS

A B
1. PROJECT NAME NO OF UNITS


IN SHEET EVALUATION I GAIN HAVE TWO COULMNS

A B
1. PROJECT NAME NO OF UNITS

I WANT THAT IF THE VALUE OF SCHEDULE!B1 GREATER THAN ZERO THEN THE CELL
OF EVALUATION!A2 SHOULD REFLECT THE VALUE OF THE VALUE OF SCHEDULE!A1

Right now i am using the below mentioned formulae which is not working.
Me getting an output as 0.

=IF(TRIM(SCHEDULE!B1)="","",IF(SCHEDULE!B10,(EVAL UATION!A2=SCHEDULE!A2)))

What should i do. Where i m lagging. Pls help me in this regards.

Thanks in Advance & wishing you a very happy new year.

Akash