Hi!

You have a conflict in logic here!

If Bill Gates sales are $1 billion his bonus could be either/or by your
description!

The best solution to this depends on how many conditions there are. Just
using the 2 you posted:

Let's make the levels logic friendly:

1 billion or greater = 15%
Less than 1 billion = 10%

A1 = sales

Formula to calculate bonus:

=IF(A1>=1000^3,A1*0.15,A1*0.1)

Biff

"james1bo" <james1bo.1tzlef_1124413509.6885@excelforum-nospam.com> wrote in
message news:james1bo.1tzlef_1124413509.6885@excelforum-nospam.com...
>
> im trying to set up a formula to give me a number based on the criteria
> of a cell. My goal is setting up a work sheet for a bonus plan. Bonus
> are only payed at a higher percentage after a certain amount.
>
> Example.
>
> if bill gates sales are 1 billion dollars or more, then his bonus is
> 15%... or ... if bill gates sales are 1 billion dollars or less, his
> bonus will be 10%... ect ect...
>
> any good Office Heads out there that can give this frustrated hardware
> engineer advice???? I can build them, trouble shoot them,, and repair
> them,, but when it comes to computer software and excell formulas,,, it
> might as well be an Apple... lol
> thanks for any help.
> Jim
>
>
> --
> james1bo
> ------------------------------------------------------------------------
> james1bo's Profile:
> http://www.excelforum.com/member.php...o&userid=26437
> View this thread: http://www.excelforum.com/showthread...hreadid=397064
>