If This - If That

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

Excel 2000 Issue

This is what I want to accomplish.
I have two workbooks

Workbook A
In cell D9 the value could be 100 or less than 100.

Workbook B
If cell D9 in workbook A is 100, I want a "Y" placed in
cell F8 of workbook B - If the value in cell D9 in
workbook A is less than 100, I want a "N" placed in cell
F8 of workbook B

Thank you for your help & valuable time
 
Hi Karen!

Try following for F8 in Workbook B
=IF('[My First Workbook.xls]Sheet5'!$D$9=100,"Y",IF('[My First
Workbook.xls]Sheet5'!$D$9<100,"N",""))

But as a general tip, just use the standard approach of:

Select F8 of
Type:
=IF(
Navigate to D9 of the first workbook and select D9 then type:
=100,"Y",IF(
Navigate to D9 of the first workbook and select D9 then type:
<100,"N",""))
Enter

If you are going to copy this formula down or across, you will have to
alter the absolute reference to D9

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thank you so much for your help Norman - I'll try it and
see how it works.
Have a great day!
-----Original Message-----
Hi Karen!

Try following for F8 in Workbook B
=IF('[My First Workbook.xls]Sheet5'!$D$9=100,"Y",IF('[My First
Workbook.xls]Sheet5'!$D$9<100,"N",""))

But as a general tip, just use the standard approach of:

Select F8 of
Type:
=IF(
Navigate to D9 of the first workbook and select D9 then type:
=100,"Y",IF(
Navigate to D9 of the first workbook and select D9 then type:
<100,"N",""))
Enter

If you are going to copy this formula down or across, you will have to
alter the absolute reference to D9

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Karen said:
Excel 2000 Issue

This is what I want to accomplish.
I have two workbooks

Workbook A
In cell D9 the value could be 100 or less than 100.

Workbook B
If cell D9 in workbook A is 100, I want a "Y" placed in
cell F8 of workbook B - If the value in cell D9 in
workbook A is less than 100, I want a "N" placed in cell
F8 of workbook B

Thank you for your help & valuable time
Click to expand...


.
Click to expand...
 
Back
Top