IF Statement to amend another workbook

[LouiseH24]

Hiya,

A bit general I know, but is it possible to write an IF statement to updates another workbook?

Thanks

Louise

[Special-K]

The IF statement would have to BE in the other workbook.
A VBA approach would be another way

[roki4]

Yes, the "if" statement would pull values from another workbook and update the workbook that it is written in.

Example: =IF(ISBLANK('INSERT FILE PATH HERE'!$J$8), "No", "Yes")

This one checks to see if the cell in the other workbook is blank and returns values Yes or No in the cell that the "if" statement is written in (J8 in this case).

[LouiseH24]

Thanks guys - some great solutions