# Thread: Greater Than, Less Than formula (Excel 2000)

1. ## Greater Than, Less Than formula (Excel 2000)

I am having trouble with a formula that needs to read the following way:

If the actual total is greater than 85% (but less than 91%), then the percent payout will be 2%. If the actual total is greater than 90% (but less than 100%), the percent payout will be 4%. If the actual total equals 100%, the percent payout will be 6%.

I'm having a difficult time because I can't seem to enter "greater than but less than" in the same statement. Looking at Row 7. Please see attached doc.

2. ## Re: Greater Than, Less Than formula (Excel 2000)

Try a formula like this:

<code>=IF(B3<85%,0%,IF(B3<90%,2%,IF(B3<100%,4%,6%) ))</code>

It is not quite clear whether to use < or <= since your description is contradictory (less than 91% and greater than 90% overlap)

3. ## Re: Greater Than, Less Than formula (Excel 2000)

=SUM(IF(B3=1,0.6,IF(B3>0.9,0.04,IF(B3>0.85,0.02,0) )))

I am not sure what to do with 0.90 - 0.91 since you have some overlap so I ignored this.

Steve

#### Posting Permissions

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