# Thread: IF statement formula

1. I am trying to inset a IF statement that inserts 7% if cell is greater than 99999 and inserts 5% if cell is less than 100000. I would really appreciate any help.

2. [quote name='hma' post='776865' date='26-May-2009 00:52']I am trying to inset a IF statement that inserts 7% if cell is greater than 99999 and inserts 5% if cell is less than 100000. I would really appreciate any help.[/quote]

Hi

I am confused on your requirement
if the cell >99999 and < 100000, what would you want to insert? 5% or 7%?
if the cell value is neither >99999 or < 100000, what result would you want?

3. Welcome to the Lounge!

Let's say the cell with the number is A1.
The following formula, entered in another cell, will return 7% or 5% depending on the value of A1:

=IF(A1>=10000,7%,5%)

You may have to format the cell with the formula as a percentage.

4. Thanks Hans, that worked!!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•