Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

« previous next »
Pages: [1]   Go Down

Author Topic: excel 2010  (Read 3598 times)

0 Members and 1 Guest are viewing this topic.

help123

    Topic Starter


    Newbie

    • Experience: Beginner
    • OS: Windows 7
    excel 2010
    « on: June 19, 2013, 06:35:49 PM »
    If cell A1 is a empty cell and in cell A2 I have =if(A1>=0, 5%, ""), how can i have the forumla return nothing rather that 5%.  Excel treats the empty cell as a 0 which I dont want it to, just as a empty cell
    Logged

    DaveLembke



      Sage
      • Thanked: 662
    • Certifications: List
    • Computer: Specs
    • Experience: Expert
    • OS: Windows 10
    Re: excel 2010
    « Reply #1 on: June 21, 2013, 06:28:07 PM »
    Have you tried formating cell A1 to be "text" instead of default in which it expects a number. Not sure of this will fix it as for I cant test this on this computer I am at.
    Logged

    soybean



      Genius
    • The first soybean ever to learn the computer.
      • Thanked: 469
    • Computer: Specs
    • Experience: Experienced
    • OS: Windows 10
    Re: excel 2010
    « Reply #2 on: June 22, 2013, 07:44:15 AM »
    What if A1 was an erroneous negative # or text?  I think a nested IF statement is probably what you need, something like =IF(A1="","",IF(A1>=0,5%,"error")).  You may need to refine it. 
    Logged
    Pages: [1]   Go Up
    « previous next »