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


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=483493