Help! Any Microsoft Excel experts out there?

Collarspace Discussion Forums

Home Login Search

Help! Any Microsoft Excel experts out there?

View related threads: (in this forum | in all forums)

Logged in as: Guest

All Forums >> [Casual Banter] >> Off the Grid >> Help! Any Microsoft Excel experts out there?

Page: [1]

Message

<< Older Topic Newer Topic >>

Help! Any Microsoft Excel experts out there? - 2/16/2009 4:55:47 AM

MsLadySue

Posts: 2254
Joined: 12/18/2004
Status: offline

I have a project for work which is driving me crazy. Formulas in Excel are not my forte and I'm looking for some assistance.

If there is a column of figures and one needs to use a formula to find the numbers that are >24 but <60 how would this formula be written? I've tried everything I can think of, but no success.

Any assistance would be greatly appreciated.

< Message edited by MsLadySue -- 2/16/2009 4:56:36 AM >

_____________________________

In order for you to insult me, I would first have to value your opinion.
I love it when someone insults me. That means I don't have to be nice anymore.

Profile

Post #: 1

RE: Help! Any Microsoft Excel experts out there? - 2/16/2009 4:57:35 AM

subtlebutterfly

Posts: 2230
Joined: 6/15/2008
From: Not your hood
Status: offline

i don't remember how at the moment..but you use the IF formula..or countif or errr gonna check :P
um.. if you're looking to find the numbers...you could just sort the columns according to the numbers, no formula needed

Let me know if this works:
COUNTIFS(A2:A7,">24",A2:A7,"<60")

< Message edited by subtlebutterfly -- 2/16/2009 5:16:09 AM >

(in reply to MsLadySue)

Profile

Post #: 2

RE: Help! Any Microsoft Excel experts out there? - 2/16/2009 5:22:57 AM

BBBTBW

Posts: 836
Joined: 5/21/2004
Status: offline

I went straight to the help menu on excel and asked the question, "how do I use the IF function" It gave me the answer that should answer your question.

Correct me if I am wrong but do you mean greater than 24 and less than 60. if so you transposed the symbols.

< Message edited by BBBTBW -- 2/16/2009 5:24:49 AM >

_____________________________

"You keep using that word, I do not think it means what you think it means" -- Inigo Montoya, The Princess Bride

(in reply to subtlebutterfly)

Profile

Post #: 3

RE: Help! Any Microsoft Excel experts out there? - 2/16/2009 6:13:20 AM

DarkSteven

Posts: 28072
Joined: 5/2/2008
Status: offline

Use the AND function.

If your numbers are in column A, then go to an adjacent cell in Column B and click on the Insert tab, then Function, Excel will step you through how to use the AND function, and you'll be using two IFs within it.

_____________________________

"You women....

The small-breasted ones want larger breasts. The large-breasted ones want smaller ones. The straight-haired ones curl their hair, and the curly-haired ones straighten theirs...

Quit fretting. We men love you."

(in reply to BBBTBW)

Profile

Post #: 4

RE: Help! Any Microsoft Excel experts out there? - 2/16/2009 7:35:19 AM

MsLadySue

Posts: 2254
Joined: 12/18/2004
Status: offline

I thank everyone for their assistance. After much guessing and playing with formulas I figured it out.

subtlebutterfly, your formula didn't work, but thanks for trying.

BBBTBW looking in help is okay if one understands the basics of what is being explained, for me it's not that easy. No my symbols were not transposed >24 (greater than 24)
and <60 (less than 60)

_____________________________

In order for you to insult me, I would first have to value your opinion.
I love it when someone insults me. That means I don't have to be nice anymore.

(in reply to DarkSteven)

Profile

Post #: 5

RE: Help! Any Microsoft Excel experts out there? - 2/16/2009 11:19:49 AM

GimpinDenial

Posts: 1145
Joined: 4/20/2008
Status: offline

Ok....I do not know Excel....
but I know the language of formulas...
Placing this into C1:
=IF(AND(A1:>24=TRUE,A1:<60=TRUE),B1,"False")

Hope this helps, and I will CMail it to you in case it does not get approved in time...
-Gimp

< Message edited by GimpinDenial -- 2/16/2009 11:44:13 AM >

_____________________________

Resident Gimp
I can only hope that in death, the sins of my life will be forgiven.

(in reply to MsLadySue)

Profile

Post #: 6