Excel Wizarsds I need help!

Posted By Message

lullabella
LIF Adult

Member since 5/05

2246 total posts

Name:

Excel Wizarsds I need help!

Is anyone really good with excel databases? If so would you be willing to help me out with something?

Posted 10/28/08 1:52 PM
 
Long Island Weddings
Long Island's Largest Bridal Resource

Kate
*****

Member since 5/05

7557 total posts

Name:
Kate

Re: Excel Wizarsds I need help!

I'm pretty good with Excel. What's the issue?

Posted 10/28/08 1:56 PM
 

lullabella
LIF Adult

Member since 5/05

2246 total posts

Name:

Re: Excel Wizarsds I need help!

Posted by Kate

I'm pretty good with Excel. What's the issue?



It is pretty complex, I had a consultant create something for me and I want to change the formula to recognize one decimals.

So for example now it works it you have a 4 you get 10%. I want to change it to if you have between a 3.5 - 4.0 you get 10%. Does this make sense?

Posted 10/28/08 2:12 PM
 

Kate
*****

Member since 5/05

7557 total posts

Name:
Kate

Re: Excel Wizarsds I need help!

Posted by lullabella

Posted by Kate

I'm pretty good with Excel. What's the issue?



It is pretty complex, I had a consultant create something for me and I want to change the formula to recognize one decimals.

So for example now it works it you have a 4 you get 10%. I want to change it to if you have between a 3.5 - 4.0 you get 10%. Does this make sense?




Sorry, not sure how to do that. Chat Icon

Posted 10/28/08 4:53 PM
 

Jenn627
Laaaaaaaambert!

Member since 5/08

9818 total posts

Name:
Jenn

Re: Excel Wizarsds I need help!

how does the formula read now?

edit to be more clear - can you post the formula as it reads now?

Message edited 2008-10-28 17:14:15.910000.

Posted 10/28/08 5:13 PM
 

BabyBoy
is Skylar Elizabeth

Member since 5/05

4189 total posts

Name:
Tom

Re: Excel Wizarsds I need help!

this is a formating issue.

right click on cell, row or column, select
format cells, select percentage, then number of decimal places...in your case, 1

i fully don't understand your question, cause you wrote 3.5-4.0 then you get 10%. If it were 3.5 and there were no decimal places, it would round up to 4%

Message edited 2008-10-28 18:26:06.563000.

Posted 10/28/08 6:24 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
where can i download microsoft excel for free?? w/no viruses? raken40 10/24/05 3 Families Helping Families ™
Need help with Excel and Word - Mass Mailings Marcie 8/4/06 9 Families Helping Families ™
Excel file to pdf? KPtoys 5/1/06 13 Families Helping Families ™
Dumb excel question JenniferEver 4/23/06 3 Families Helping Families ™
Excel Question MsG 4/17/06 5 Families Helping Families ™
PowerPoint and Excel.. LBG30 10/18/05 6 Families Helping Families ™