| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function (..........
=IF(B22=20,[link to prices.xls],"")
You just have to create the link when you're constructing the formula. Without knowing the specifics of what you're trying to do it's impossible to give you a more detailed answer than that. -- Brevity is the soul of wit. "MichelleS" wrote: How can I write an IF formula where I can type a NUMERIC value in one cell and the adjacent cell automatically types TEXT selected from another Excel Workbook? Example: While in Workbook (Estimates.xls) in cell C22, I want to type an IF formula -- IF(B22=20,C22=text from another cell in another Workbook). The other workbook is 'Prices.xls' |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
