Excel Help!

Posted By Message

rkl1130
LIF Adult

Member since 10/07

1476 total posts

Name:
Rose Ann

Excel Help!

Hi Guys!

I don't know if this is the right place to put this, but I've been working on a formula forever and I just can't seem to find where I've gone wrong and it's annoying me. I'm trying to write an "IF" formula, but it doesn't seem to be working and it's only reading the first condition and everything else is coming out as "FALSE."

Can anyone with great excel formula writing skills help.

=IF(E8<=10,"$1-$10M",IF(10<E8<=25,"$10-$25M",IF(25<E8<=50,"$25-$50M",IF(50<E8<=75,"$50-$75M",IF(75<E8<=100,"$75-$100M",IF(100<E8<=150,"$100-$150M",IF(150<E8<=200,"$150-$200M")))))))

Posted 4/5/12 4:24 PM
 
Long Island Weddings
Long Island's Largest Bridal Resource

Andrewz00
Look! I changed it!

Member since 4/10

1789 total posts

Name:
Andrew

Re: Excel Help!

Posted by rkl1130
=IF(E8<=10,"$1-$10M",IF(10<E8<=25,"$10-$25M",IF(25<E8<=50,"$25-$50M",IF(50<E8<=75,"$50-$75M",IF(75<E8<=100,"$75-$100M",IF(100<E8<=150,"$100-$150M",IF(150<E8<=200,"$150-$200M")))))))



i would re-write the second condition...

instead of if(10<E8<25...

i would write if(and(E8>10,E8<25)...

if(E8<10, "$1--" ,(
if(and(e8>10,e8<=25), "$10-.."

Posted 4/5/12 4:48 PM
 

LSP2005
Bunny kisses are so cute!

Member since 5/05

19461 total posts

Name:
L

Re: Excel Help!

those conditions are redundant since they are in the false part of the first condition.
For instance: if the first test is true the value is less than 10, if the first test is false it looks at the second condition - so you don't need to test for > 10 there.

The resulting formula is:

=IF(E8<=10,"$1-$10M",IF(E8<=25,"$10-$25M",IF(E8<=50,"$25-$50M",IF(E8<=75,"$50-$75M",IF(E8<=100,"$75-$100M",IF(E8<=150,"$100-$150M",IF(E8<=200,"$150-$200M","Over $200M")))))))

Posted 4/5/12 9:27 PM
 

JEKS1219
LIF Infant

Member since 9/08

163 total posts

Name:
Jen

Re: Excel Help!

When you build a nested if statement you can only nest 7 conditions, but you can use and , not, or to help. What I would do is say =if(or(

Once you get to this point press the fx button and enter your conditions

Use and here...

<=10
AND >10, <25


And continue that way

Kinda hard to type on iPad, fm if you need help

Posted 4/6/12 8:34 AM
 

rkl1130
LIF Adult

Member since 10/07

1476 total posts

Name:
Rose Ann

Re: Excel Help!

Thank you ladies!

You were all a huge help. I use Excel all the time but always sucked at formula.Chat Icon

Posted 4/6/12 9:11 AM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
Anyone know how to transfer addresses from Microsoft excel.... jlk51496 1/29/12 2 Families Helping Families ™
Can a Word doc be merged into an Excel doc? NFT Smileyd17 7/9/09 1 Families Helping Families ™
Excel Wizards... nevermind! Lucky09 5/10/08 0 Families Helping Families ™
can you format a table in Word, the same way you can in Excel? randella 6/13/07 3 Families Helping Families ™
my excel freaking crashed- I lost 2 hours worth of work! Beth 1/24/07 8 Families Helping Families ™
where can i download microsoft excel for free?? w/no viruses? raken40 10/24/05 3 Families Helping Families ™