How to obtain +ve and -ve value in MS-Excel

[aashoo]

somebody asked me this and I was clueless. Sample -> values are +5, +3, -3, -5, -7 and have to subtract 0.1 from all.

I said formula should be IF value of a1 is +ve then a1-0.1 OR if it is -ve then a1=0.1

question is how to measure +ve and -ve of the value in the cell.

[aashoo]

I think I got it

I ll suggest to put >=0 and < 0

thanks `

[HarHarMahaDev]

I have another tip for you:

If you are browsing and accidentally click on a link and you want to navigate to the previous page, then you can simply click on the 'back' button and it will take you back to your original page.

I know this has no relation to your problem, but I thought you might find this tip helpful.

[sarv_shaktimaan]

here's your formula buddy... =IF(A1>0,A1-0.1,-(-A1-0.1))... lemme know if it works...

[TerminatorJR]

Originally Posted by aashoo

I think I got it

I ll suggest to put >=0 and < 0

thanks `

Yup.
=IF(A1:A5>=0,A1-0.1,0.1)
hehe.

[28virgo]

Originally Posted by HarHarMahaDev

I have another tip for you:

If you are browsing and accidentally click on a link and you want to navigate to the previous page, then you can simply click on the 'back' button and it will take you back to your original page.

I know this has no relation to your problem, but I thought you might find this tip helpful.

Dang! how come you know all these really smart things?

Thanks for the tip!

[aashoo]

I m bored may be because its friday afternoon


okay here is one for the friday and really stinky one

A man and his wife have gone to bed. After laying in bed for a few minutes the man cuts a fart. His wife rolls over and asks, “What in the world was that?”

The man says, “Touchdown, I’m ahead, seven to nothing.”

A few minutes later the wife lets one loose. The man says to her, “What was that?”

She replies, “Touchdown, tie score.”

The man lays there for about ten minutes trying to work another one up. He tries so hard that he craps all over the bed.

The wife asks, “Now what in the world was that?” He replies, “Half time. Switch sides.”

[TerminatorJR]

Originally Posted by aashoo

I m bored may be because its friday afternoon


okay here is one for the friday and really stinky one

A man and his wife have gone to bed. After laying in bed for a few minutes the man cuts a fart. His wife rolls over and asks, “What in the world was that?”

The man says, “Touchdown, I’m ahead, seven to nothing.”

A few minutes later the wife lets one loose. The man says to her, “What was that?”

She replies, “Touchdown, tie score.”

The man lays there for about ten minutes trying to work another one up. He tries so hard that he craps all over the bed.

The wife asks, “Now what in the world was that?” He replies, “Half time. Switch sides.”

Repeat.

aashoo TerminatorJR

Touchdown.

[aashoo]

This is my kindergartener’s artistic rendering of a pair of scissors. I wonder what his teacher thought… I allowed myself just a small smirk when I saw it. I waited until he was out of the room before I started crying, from laughing so hard.




Well, of course they’re scissors. If you know someone with small children or you’re a teacher… you will love this! I can certainly imagine seeing this proudly displayed on a mother’s fridge at home…

[aashoo]

Originally Posted by TerminatorJR

Repeat.

aashoo TerminatorJR

Touchdown.

you are more bored than me today termi

find some jokes on google and lighten up a bit instead

[aashoo]

There was a chicken and a horse playing together on a farm one day. The horse fell into a mud pit and yelled to the chicken to run to the house and get the farmer. The chicken ran to the house and the farmer was nowhere to be found. So, it got into the farmer’s Mercedes and pulled the horse out with it.

The next day the chicken and the horse were playing on the farm again. This time the chicken fell into the mud pit and yelled to the horse to get help. So, the horse stood over the mud pit and told the chicken to grab on to his penis and he’d pull him out. The chicken grabbed on and, indeed, the horse pulled him out.

Moral of the story: If you’re hung like a horse, you don’t need a Mercedes to pick up chicks.

[HarHarMahaDev]

A patient wakes up from a coma "Doctor Doctor!! I cannot feel my legs!"

"Of course, you silly!" said the doctor, "I cut off your hands."

[28virgo]

A woman is in her doctors office and suddenly shouts, "Doctor, kiss me!"
The doctor looks at her and says, "I'm sorry, but it would be against my code of ethics to kiss you."

Twenty minutes later the woman shouts again, "Doctor, please kiss me!"
Again he refuses, apologetically, and says, "As a doctor I simply cannot kiss you."

Finally after another fifteen minutes the woman pleads with the doctor again, "Please, please kiss me, just once!"

"Look," he says. "I am sorry. I just CANNOT kiss you, in fact I probably shouldn't even be f**king you."

[28virgo]

Little Tony was staying with his grandmother for a few days. He'd been playing outside with the other kids for a while when he came into the house and asked her, "Grandma, what's that called when two people sleep in the same room and one is on top of the other?"

She was a little taken aback, but she decided to just tell him the truth.
"It's called se_xual intercourse, darling."

Little Tony just said, "Oh, OK," and went back outside to play with the other kids. A few minutes later he came back in and said angrily,
"Grandma, it isn't called se_xual intercourse. It's called Bunk Beds. And Jimmy's Mom wants to talk to you."