I am trying to create a quote sheet that includes several cells that refer to
price values in a different workbook. I figured out how to referance the
other workbook, but I can't seem to formulate a calculation with only cells
in a string that are choosen with a value. For example, row 2 includes
several different product variations from B:M which should only be calculated
if a value (quantity) is entered. Such as 2-B2 and 1-D2. Heres how I've tried
to write the formula to be entered in N2:
B2*'[otherworkbook]!'$A$4+C2*'[otherworkbook]!'$G$12...etc...
The problem is that the formula is calculating cells in the destination that
have not been chosen with a value in the cell.
I only want the cells in the row that have been chosen with a value
(quantity) to be calculated.
Sorry about my inexperiance with exel

You will need to surround your formula with an If statement, as in:

=if(a1="","",yourformula)

--
Regards,
Fred


"Novice" wrote in message
...
I am trying to create a quote sheet that includes several cells that refer to
price values in a different workbook. I figured out how to referance the
other workbook, but I can't seem to formulate a calculation with only cells
in a string that are choosen with a value. For example, row 2 includes
several different product variations from B:M which should only be calculated
if a value (quantity) is entered. Such as 2-B2 and 1-D2. Heres how I've tried
to write the formula to be entered in N2:
B2*'[otherworkbook]!'$A$4+C2*'[otherworkbook]!'$G$12...etc...
The problem is that the formula is calculating cells in the destination that
have not been chosen with a value in the cell.
I only want the cells in the row that have been chosen with a value
(quantity) to be calculated.
Sorry about my inexperiance with exel

dont be afraid to use helper cells,it makes it more transparent and
obviousHave your price linked in one cell,quantity in another and result in
another.Then a seperate sum for all the seperate results.
--
paul

remove nospam for email addy!



"Novice" wrote:

I am trying to create a quote sheet that includes several cells that refer to
price values in a different workbook. I figured out how to referance the
other workbook, but I can't seem to formulate a calculation with only cells
in a string that are choosen with a value. For example, row 2 includes
several different product variations from B:M which should only be calculated
if a value (quantity) is entered. Such as 2-B2 and 1-D2. Heres how I've tried
to write the formula to be entered in N2:
B2*'[otherworkbook]!'$A$4+C2*'[otherworkbook]!'$G$12...etc...
The problem is that the formula is calculating cells in the destination that
have not been chosen with a value in the cell.
I only want the cells in the row that have been chosen with a value
(quantity) to be calculated.
Sorry about my inexperiance with exel