Display value from another workbook, if less than display a blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
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 Noo
 
aldutson said:
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"
Click to expand...

=IF(OR(ISBLANK([Book2]Sheet1!$A$1),[Book2]Sheet1!$A$1=0),"",[Book2]Sheet1!$A$1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
# Value error and how to ignore blank cells 2
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
If function across sheets prints value of cell 4
Linking sheets how do I display the zeros (0) as blank cells 1
Don't know if it's possible, but... 1
Convert 0 value cells to "text" 7

Back
Top