ExcelBanter - 0 instead of nothing?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - 0 instead of nothing? (https://www.excelbanter.com/excel-programming/429429-0-instead-nothing.html)

Mia

0 instead of nothing?

Hello,

When Im making formulas like =Fakturaunderlag!L6
Im getting 0 instead of a empty cell as it should be,
how do I fix this?

--
Best regards
Mia

Jacob Skaria

0 instead of nothing?

Handle that using IF

=IF(Fakturaunderlag!L6="","",Fakturaunderlag!L6)

If this post helps click Yes
---------------
Jacob Skaria

"Mia" wrote:

Hello,

When Im making formulas like =Fakturaunderlag!L6
Im getting 0 instead of a empty cell as it should be,
how do I fix this?

--
Best regards
Mia

Mia

0 instead of nothing?

Thank you!

You saved med twice in 24 hours now! Have a nice weekend!

--
Best regards
Mia

"Jacob Skaria" skrev:

Handle that using IF

=IF(Fakturaunderlag!L6="","",Fakturaunderlag!L6)

If this post helps click Yes
---------------
Jacob Skaria

"Mia" wrote:

Hello,

When Im making formulas like =Fakturaunderlag!L6
Im getting 0 instead of a empty cell as it should be,
how do I fix this?

--
Best regards
Mia

All times are GMT +1. The time now is 10:45 AM.