Excel

[Cindy D]

Is is possible to create formulas to calculate from one workbook to another?

[swatsp0p]

Is is possible to create formulas to calculate from one workbook to another?

Yes. Simply reference the other workbook, sheet name and cell reference in your formula as:

=IF('C:\Documents and Settings\[Book1.xls]Sheet2'!$C24<>"",'C:\Documents and Settings\[Book1.xls]Sheet2'!$C24,'C:\Documents and Settings\[Book1.xls]Sheet10'!$L24)

note the syntax is: 'path\[workbook]SheetName!'CellReference

good luck