Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|