IF FUNCTION
 

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

IF FUNCTION
 

In Evaluation!A2 use

=IF(SCHEDULE!B10,SCHEDULE!A1,"")


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Akash" wrote in message
ups.com...
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

IF FUNCTION
 

Can I have the macro for the same.

If its possible.

Akash

On Jan 2, 3:14 pm, "Bob Phillips" wrote:
In Evaluation!A2 use

=IF(SCHEDULE!B10,SCHEDULE!A1,"")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

"Akash" wrote in oglegroups.com...

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