I need some help, as I have not able to come up with a formula. Any
assistance would be greatly appreciated...

So lets say you have a value in cell A1...I need a formula in cell B1
calculating based on the value of cell A1 with the folowing conditions...If
the value of A1 is less than 500, I need to multiply it by 40%; if the value
of A1 is between 500 and 750, I need to multiply it by 35%; if the value is
between 750 and 1000 need to multiply it by 30% and if its greater than 1000,
then multiply it by 20%...

Thanks for the Help...Fred