IF FUNCTION

[Akash]

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!B1>0,(EVALUATION!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

 

[Bob Phillips]

In Evaluation!A2 use

=IF(SCHEDULE!B1>0,SCHEDULE!A1,"")


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Akash]

Can I have the macro for the same.

If its possible.

Akash