excel 03, remove unwanted results data, ASAP?

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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
 

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
 

Attachments

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.
 

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
 
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.
 

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
 

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?
 
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?
 

jimr381

Jim
Joined
Jul 20, 2007
Messages
4,193
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. ;)
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Members online

Top