1. ## if statement (excel)

I'm having a tough time with an if statement. Here's what I'm trying to do:
if the value is less than 100% then equal 0. If it equals 100% then equal 4%.
if the value is between 100% and 105% then equal 6%
if the value is greater than 105.1% then equal 8%.

2. ## Re: if statement (excel)

If the value is in A1, then try something like:

<pre>=IF(A1<1,0,IF(A1<=1.05,0.06,0.08))
</pre>

3. ## Re: if statement (excel)

it works accept at the 100%. I need it to equal 4% at 100%.

Everything else is great.
Thanks

4. ## Re: if statement (excel)

I think Legare may have overlooked the second sentence on your second line. Is this OK?

=IF(A1>=1,IF(A1=1,0.04,IF(A1<=1.05,0.06,0.08)),)

5. ## Re: if statement (excel)

Legare, you forgot the case A1=100%.
<pre>=IF(A1<100%,0,IF(A1=100%,4%,IF(A1<=105%,6%,8% )))
</pre>

Note 1: it is possible to use percentages in formulas.
Note 2: don't forget to format the cell with the formula as a percentage (this is not automatic)

6. ## Re: if statement (excel)

Thanks everyone. Works great!

#### Posting Permissions

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