if than statements

[Biff]

Hi Kam,

A couple of things that need to be resolved.

I think you basic data values are incorrect:

25,000,000 x .06 = 1,500,000 (150,000)
25,000,000 x .05 = 1,250,000 (125,000)
...

Also, based on the fee schedule, there is no fee imposed
on any value >128mm. The basic formula for this is pretty
simple but you need to define what to do with amounts

128mm. Do you want one single formula for the whole

amount or a seperate formula for each fee level?

Can you provide more info on this?

Biff