+ Reply to Thread
Results 1 to 2 of 2

Make returned cells that is =<0 to empty

  1. #1
    Registered User
    Join Date
    02-12-2009
    Location
    oslo, Norway
    MS-Off Ver
    Excel 2010
    Posts
    45

    Make returned cells that is =<0 to empty

    Hello agian, I have a formula that calculates values...

    Now, I want exel to set all returned values that is 0 or below to "" (empty).

    formula;
    =IF(CG36="slakteklar";(CD37-CD46);IF(CG36="sulting";CF37;((CG36/1000)*CG35)))

  2. #2
    Forum Contributor
    Join Date
    02-14-2007
    Location
    Chester, England
    MS-Off Ver
    2010 & 2016
    Posts
    312

    Re: Make returned cells that is =<0 to empty

    Hi

    This should work.

    =IF(IF(CG36="slakteklar",(CD37-CD46),IF(CG36="sulting",CF37,((CG36/1000)*CG35)))=0,"",IF(CG36="slakteklar",(CD37-CD46),IF(CG36="sulting",CF37,((CG36/1000)*CG35))))
    Cheers

    James

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1