This is just beyond my expertise. Cell i87 contains may contain any positive, negative or zero value. I am only concerned with performing a calculation in J87 when I87 contains a positive value.
So, when I87 is greater than 1,000,000, J87 should be (I87-1,000,000) x 7.6% + 56,000.
when I87 is >500,000 but less then <1,000,000, then J87 should be (I87-500,000) x 6.4% + 24,000.
when i87 > 0 but less then 500,000 then j87 should (i87 X 4.8%)