Formulas in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help. I am trying to find the best formula to use to solve the
following problem. If cell F8 is less than zero then the answer should be
0%, if F8 is between 0% and 4.99% then the answer should be 2%, if F8 is
between 5% and 9.99% then 4% and then if F8 is 10% or greater then 6%. Is
there a function that can help me with this problem?
 
Becky said:
I need help. I am trying to find the best formula to use to solve the
following problem. If cell F8 is less than zero then the answer
should be 0%, if F8 is between 0% and 4.99% then the answer should be
2%, if F8 is
between 5% and 9.99% then 4% and then if F8 is 10% or greater then 6%.
Is there a function that can help me with this problem?
Click to expand...

Post your question in a group specifically for Excel. Here is a list of
all the MS newsgroups so you can find the right one:

http://aumha.org/nntp.htm

Malke
 
Strictly speaking, your criteria has gaps, e.g. where to include 4.991 or
9.991? However, the following formula will give you something you can tweak
to suit your needs.
=IF(F8<0,0%,IF(F8<=4.99,2%,IF(F8<=9.99,4%,6%)))
 
It will not allow me to send a message. I get the following message:

Outlook Express could not post your message. Subject 'need help with
formula', Account: 'msnews.microsoft.com', Server: 'msnews.microsoft.com',
Protocol: NNTP, Server Response: '502 Permission denied', Port: 119,
Secure(SSL): No, Server Error: 502, Error Number: 0x800CCC18
 
Becky said:
It will not allow me to send a message. I get the following message:

Outlook Express could not post your message. Subject 'need help with
formula', Account: 'msnews.microsoft.com', Server:
'msnews.microsoft.com', Protocol: NNTP, Server Response: '502
Permission denied', Port: 119, Secure(SSL): No, Server Error: 502,
Error Number: 0x800CCC18 "Malke" wrote:
Click to expand...
What will not allow you to send a message to whom? Here are instructions
how to set up OE as a newsreader:

http://michaelstevenstech.com/outlookexpressnewreader.htm - Set Up
Newsreader
http://rickrogers.org/setupoe.htm

Malke
 
Becky said:
I need help. I am trying to find the best formula to use to solve the
following problem. If cell F8 is less than zero then the answer should be
0%, if F8 is between 0% and 4.99% then the answer should be 2%, if F8 is
between 5% and 9.99% then 4% and then if F8 is 10% or greater then 6%. Is
there a function that can help me with this problem?
Click to expand...

I'm sure there is and the contributors in an Excel newsgroup
would love to tell you how to do it.
 
Pegasus (MVP) said:
I'm sure there is and the contributors in an Excel newsgroup
would love to tell you how to do it.
Click to expand...


Excel has built in help- it's amazing just how many people don't think of
looking there!
search for conditional.

One way to do this is using the if function, up to seven if's can be nested
which is more than enough here. There are other solutions too, but as you
say this isn't really an excel group so I'll stop there.

Good Luck to the OP
 
Back
Top