Excel Help!
| Posted By | Message |
|---|---|
|
Excel Help! Hi Guys! |
|
Posted 4/5/12 4:24 PM
|
|
|
Long Island Weddings
Long Island's Largest Bridal Resource
| |
|
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
|
|
|
Re: Excel Help! those conditions are redundant since they are in the false part of the first condition. |
|
Posted 4/5/12 9:27 PM
|
|
|
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( |
|
Posted 4/6/12 8:34 AM
|
|
|
Re: Excel Help! Thank you ladies! |
|
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 ™ |



