| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display value from another workbook, if less than display a blank
I want to display the value of a cell from another workbook. If the cell
from the other worksheet is empty or the value is "0" then I want to display a blank cell rather than a "0" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display value from another workbook, if less than display a blank
Hi, Use a if statement and isn't blank "<" Adapt the formula to your sheet name and cell ref =IF([Book2]Sheet5!$C$7<"",[Book2]Sheet5!$C$7,"") VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=565475 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display value from another workbook, if less than display a blank
"aldutson" wrote in message
... I want to display the value of a cell from another workbook. If the cell from the other worksheet is empty or the value is "0" then I want to display a blank cell rather than a "0" =IF(OR(ISBLANK([Book2]Sheet1!$A$1),[Book2]Sheet1!$A$1=0),"",[Book2]Sheet1!$A$1) -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
| Open Blank Workbook? | Excel Discussion (Misc queries) | |||
| Can I display the file properties of a workbook in a custom headi. | Excel Worksheet Functions | |||
| On the Task Bar, can I display the workbook title when minimized . | Setting up and Configuration of Excel | |||
| Unprotect Workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
