If This - If That

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
 
Top