Here is my formula.
=IF(Sheet1!J5=$J$4,0,(Sheet1!$J$4-Sheet1!J5)*Sheet1!$J$1)
It is perfect, except it doesn't have one final step. What I need it to do
is be able to do that ONLY if it is greater than or less than by a specified
amount. So there needs to be a modification of ...Sheet!J5<> (but by 100 or
any other number that I set) $J$4,...

Thanks so much for the help!

Brandon