I am trying to create a quote sheet using several cells in a string. While I
have figured out how to consult values in another workbook, I am unable to
write the formula so that it only calcuates those cells in the string that is
selected with a value. Example:
=B10*'[otherworkbook]!'$C$8+C10*'[otherworkbook]!'$C$9 etc..
B10 and C10 representing cells on my quote sheet that should only be
calculated when a value is entered. At this time the outcome of the formula
has a value before there is a value entered in any cell at all.
I hope you can help, and I appologize for my inexperiance with excel.
Thank you