Is is possible to create formulas to calculate from one workbook t
another?
Yes. Simply reference the other workbook, sheet name and cel
reference in your formula as:
=IF('C:\Documents an
Settings\[Book1.xls]Sheet2'!$C24<>"",'C:\Documents an
Settings\[Book1.xls]Sheet2'!$C24,'C:\Documents an
Settings\[Book1.xls]Sheet10'!$L24)
note the syntax is: 'path\[workbook]SheetName!'CellReference
good luc
