1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

excel 03, remove unwanted results data, ASAP?

Discussion in 'Business Applications' started by brion dublin, Apr 8, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. brion dublin

    brion dublin Thread Starter

    Joined:
    May 4, 2007
    Messages:
    80
    OK, It was here I first learned about ASAP utilities, wow I love that thing...
    I use it all the time..

    here's a problem I can't figure out how to use ASAP to fix

    PROBLEM:
    E.G.
    I write a formula like [=O11-Q11] into R11. and it works for row 11 just great.
    out of my 500 rows I need this to apply to about 50 various rows.
    So I drag the formula down all 500 rows.
    I get my answer in all 50 that I need.
    but the other 450 looks Messy!

    How do I remove the 0.00 & # characters from this column?
    If I do a ASAP charter removal and try to remove "0" and "." from the list it will effect my
    answers in my 50 good prices.


    thank you
    Brion
     
  2. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    Can you attach some sample data?
     
  3. brion dublin

    brion dublin Thread Starter

    Joined:
    May 4, 2007
    Messages:
    80
    here is the results of the sheet.
    you will see the problem area on the right side.

    I notice I just need to remove "0.00"


    If you figure it out please tell me how you did it.

    (I image there is a way to tell ASAP or the excel formula to only give an answer where it is needed, or only give an answer 0.01 or above or -0.01 and below.)

    thanks
     

    Attached Files:

  4. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    What column am I looking at in the sample file attached?

    Did this solve your issue?
     
  5. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    Do you just not want the "0.00" to display?
     
  6. brion dublin

    brion dublin Thread Starter

    Joined:
    May 4, 2007
    Messages:
    80
    yes
    it is the column all the way to the right
    Do not want the "0.00" to display.
     
  7. brion dublin

    brion dublin Thread Starter

    Joined:
    May 4, 2007
    Messages:
    80
    basically i only want it to show a result were it is needed.
    not were it does not apply
     
  8. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    Brion,

    I am going to be honest....I do not know anything about the ASAP utility that you spoke about.

    However, If all you need to do is not show "0.00" in the "P Column", then you can use this formula....

    Code:
    =IF(OR(O38=0,L38=0),"",O38-L38)
    
    Place the formula in the first cell, and then just drag down as needed. Let me know if this is what you were looking for. If not, I will try my best to help you find a solution.
     
  9. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    Brion,

    Can you go in more details regarding this statement?
     
  10. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    You can also modify the formula like so....

    Code:
    =IF(OR(O38=0,O38="",L38=0,L38=""),"",O38-L38)
    
     
  11. brion dublin

    brion dublin Thread Starter

    Joined:
    May 4, 2007
    Messages:
    80
    I HAVE ANOTHER QUESTION THAT YOU MAY FIND EASY.
    I HAVE LEARNED TO USE YOUR FORMULA IN DIFFERENT WAYS, AND IT IS A GOOD ONE.

    WHAT IF MY RESULT IS
    "VALUE!"
    AND i WANT TO REMOVE IT, AS WELL AS THE 0.00 IN MY ANSWERS....

    I TRIED A FORULA LIKE THE
    =IF(OR(,J42=0,J42=""),"",J42*1.15)
    YOU TOUGHT ME.


    I TRIED ...
    =IF(OR(,J42=0,J42="",J24=VALUE!),"",J42*1.15)

    BUT IT DOES NOT WORK,
    DO U KNOW WHAT MIGHT?

    THANKS
     
  12. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    Can you attach a sample file with the "Value!" showing?
     
  13. brion dublin

    brion dublin Thread Starter

    Joined:
    May 4, 2007
    Messages:
    80
    i CAN'T STAND IT WHEN EXCEL WANTS TO GIVE AN ANSWER WERE IT IS NOT NEEDED,
    I WANT TO REMOVE THE RESULTS "0.00" AND " #VALUE!"

    GOOSH, I TRIED TO UPLOAD IT, IT'S TO BIG....

    WITH WHAT i TOLD U BEFORE
    ANY IDEAS OF A WAY I MIGHT CHANGE THE FORULA TO WORK?
     
  14. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    The "#Value" error occurs usually due to an equation. Is this what is happening? Without seeing what exactly is going on, it is hard to say what may be causing this error.

    Can you cut some of the data an dpaste it into a empty worksheet to upload? Is this in the same workbook that you attached previously in this thread?
     
  15. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    You could do a double test with 2 nested if functions. One looking using an iserror function to test the data. I do not really want to do this for you though since you are having issues with something in the function which need to be addressed instead of masking it as something else. I usually will nest the Iserror function within an if statement when I know I am going to get Div/0 errors, which means that you cannot divide by zero or no value.

    PS Brion all CAPS is shouting when you are dealing with electronic formats. It took me a few instant messages when my mother started using it to break her of this habit as well. ;)
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/701649

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice