I am using the formula:

```
=(Cost!C8)

```

to get values from another sheet using named ranges. I want this to only show a value if there is a value in the corresponding cell of the other sheet, however, this formula returns a value of `0` even if the cell on the other sheet is empty. How can I make it so that the formula returns nothing (is blank) when the cell it refers to is empty?

![enter image description here](https://i.stack.imgur.com/qK5Nk.png)

Invoice
![Cost price sheet](https://i.stack.imgur.com/DlqAo.png)