| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to write a quote formula using only the cells selected with va
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a formula which calculates empty cells | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Threaded Mode
