excel 03, remove unwanted results data, ASAP?

[brion dublin]

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

 

[computerman29642]

Can you attach some sample data?

 

[brion dublin]

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

 

[computerman29642]

What column am I looking at in the sample file attached?

I notice I just need to remove "0.00"

Did this solve your issue?

 

[computerman29642]

Do you just not want the "0.00" to display?

 

[brion dublin]

yes
it is the column all the way to the right
Do not want the "0.00" to display.

 

[brion dublin]

basically i only want it to show a result were it is needed.
not were it does not apply

 

[computerman29642]

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

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

 

[computerman29642]

Brion,

basically i only want it to show a result were it is needed.
not were it does not apply

Can you go in more details regarding this statement?

 

[computerman29642]

You can also modify the formula like so....

=IF(OR(O38=0,O38="",L38=0,L38=""),"",O38-L38)

 

[brion dublin]

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

 

[computerman29642]

Can you attach a sample file with the "Value!" showing?

 

[brion dublin]

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?

 

[computerman29642]

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]

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.