That only works for numbers greater than or equal to 52000.

Less than 52000 and the second half of the formula results
in a negative value.

HTH,
--
Kevin James.
Tua'r Goleuni


"Dave F" wrote in message
...
| =52000*.02+(X-52000)*.04 where X is your amount above $52,000.
|
| Dave
| --
| Brevity is the soul of wit.
|
|
| "Dos Equis" wrote:
|
| Hi all,
|
| I need to create a formula which multiplies the first $52,000 by 2% and
| anything left by 4%. Sounds easy, but It's kicking my butt. Thanks for
| any help,
|
| Byron
|
|