| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
Linear Mode
