PC Review


Reply
Thread Tools Rate Thread

0 instead of nothing?

 
 
Mia
Guest
Posts: n/a
 
      5th Jun 2009
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 With Quote
 
 
 
 
Jacob Skaria
Guest
Posts: n/a
 
      5th Jun 2009
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 With Quote
 
Mia
Guest
Posts: n/a
 
      5th Jun 2009
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



Features
 

Advertising
 

Newsgroups
 


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