If statments
I have a workbook with 2 spreadsheets, I want to create an if statment that
does the following..... in workbook 2 cell A,if workbook 2 cell J contains the letter c then put cell g from workbook c else null.... How can this be done?? |
If statments
Correction
If workbook 1 cell J contains the letter C then put cell G from workbook 1 in workbook 2 cell a else null. "Lweiss" wrote: I have a workbook with 2 spreadsheets, I want to create an if statment that does the following..... in workbook 2 cell A,if workbook 2 cell J contains the letter c then put cell g from workbook c else null.... How can this be done?? |
If statments
Hi
Assuming that you want to compare values in row 1, try this formula in cell A1 in sheet2. =IF(Sheet1!J1="C";Sheet1!G1;"") Regards, Per "Lweiss" skrev i meddelelsen ... Correction If workbook 1 cell J contains the letter C then put cell G from workbook 1 in workbook 2 cell a else null. "Lweiss" wrote: I have a workbook with 2 spreadsheets, I want to create an if statment that does the following..... in workbook 2 cell A,if workbook 2 cell J contains the letter c then put cell g from workbook c else null.... How can this be done?? |
All times are GMT +1. The time now is 03:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com